Thread
:
leap year problem.
View Single Post
#
1
Posted to microsoft.public.excel.misc
2vao
external usenet poster
Posts: 8
leap year problem.
hello,
I have this formula :
=IF(OR(MOD(B1,400)=0,AND(MOD(B1,4)=0,MOD(B1,100)< 0)),"L","NL" (to show L if
the date falls in a leap year). It works for 2008 only not for any other leap
year. please help!
thanks.
Reply With Quote
2vao
View Public Profile
Find all posts by 2vao