View Single Post
 
Old 06-26-2014, 12:17 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by shilabrow View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote