Formula to divide if no of days in month is 28

macropod · #6 06-26-2014, 12:17 AM

Quote:

Originally Posted by shilabrow

I am not getting this right - All Help appreciated.
I want to divide if no of days in month is 28 and if not then the other criteria.

Surely the only time that is true is if the month is February in a non-leap year. For the most part, therefore, all you need test with whether the month is '2' and the year divided by '4' <> '0'. I know there are more sophisticated leap-year tests, but that will suffice for any year from 1901 to 2099, inclusive.

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