Wednesday, July 9, 2008

EASTERSUNDAY() and ISLEAPYEAR()

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)

No comments:

Relax. Kick your shoes off and watch a video.