Formula to divide if no of days in month is 28

shilabrow · #1 06-25-2014, 09:05 AM

Thanks, Whatsup - Help still needed

=K6/if(day(today())=28,(Month(today()),(MONTH(TODAY())-1)*12)). when I use this I get error. I see your point though but I still need help in making the formula work.

whatsup · #2 06-25-2014, 03:24 PM

Check on the parentheses, there is something wrong, excel doesn't allow to enter the formular, but gives you some idea where to look.

Maybe that will work for you, but make sure that it meets your requirement:
=K6/IF(DAY(TODAY())=28,MONTH(TODAY()),(MONTH(TODAY())-1)*12)

shilabrow · #3 06-25-2014, 08:05 PM

Thanks Whatsup. This worked. Appreciate !!!
=k6/IF(DAY(TODAY())=28,MONTH(TODAY()),MONTH(TODAY())-1)*12

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Formula Showing Revenue Recognition Based on Days and Months	stratcat	Excel	4	03-16-2014 10:09 AM
Formula To Calculate Countdown Days To Project Completion	Catherine	Project	1	02-19-2014 11:15 AM
Formula for week days only	gbaker	Excel	5	02-15-2014 01:07 AM
Formula to count entries as per month, year and submission wise from different sheets	pinkacidpunk	Excel	1	05-28-2013 08:26 AM
formula divide by serio error	vthomeschoolmom	Excel	1	04-18-2012 02:29 PM