EASTERSUNDAY

Returns the date of Easter Sunday for the entered year.

Syntax

EASTERSUNDAY(Year)

Year is an integer in the range 1583 to 9956 or in the range 0 to 99. You can also calculate other holidays by simple addition with this date.

Easter Monday = EASTERSUNDAY(Year) + 1

Good Friday = EASTERSUNDAY(Year) - 2

Pentecost Sunday = EASTERSUNDAY(Year) + 49

Pentecost Monday = EASTERSUNDAY(Year) + 50

Examples

=EASTERSUNDAY(2000) returns 2000-04-23.

EASTERSUNDAY(2000)+49 returns the internal serial number 36688, corresponding to 2000-06-11. Format the serial date number as a date; for example the format DD/MM/YY yields 11/06/00.