Determining a leap year
Simpler, but wrong for 1900
(but as Excel didn't exist in 1900, it would only be a problem if TODAY()
were replaced in the formula by a date input or if you changed your
computer's date to 1900).
--
David Biddulph
"Jarek Kujawa" wrote in message
...
=IF(DAY(DATE(YEAR(TODAY()),3,0))=29,366,365)
is a better formula I think
|