Here are two functions.
EASTERSUNDAY(year) - You enter the year and it the function will return the date Easter falls on for that year.
ISLEAPYEAR(date) - You enter the date in a particular year and the function will return 1 if the date falls in a leap year and 0 if the date does not fall in a leap year.
Below is a screen shot.
Cell B1 contains the formula =EASTERSUNDAY(A1)
Cell B3 contains formula = ISLEAPYEAR(A3)
Cell B5 contains the formula =ISLEAPYEAR(A5)
Wednesday, July 9, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment