EASTERSUNDAY

Returns the date of Easter Sunday for the entered year. Year is an integer between 1583 and 9956 or 0 and 99. You can also calculate other holidays by simple addition with this date.

Syntax

EASTERSUNDAY(Year)

Year is an integer between 1583 and 9956 or 0 and 99. You can also calculate other holidays by simple addition with this date.

Easter Monday = EASTERSUNDAY() + 1

Good Friday = EASTERSUNDAY() - 2

Pentecost Sunday = EASTERSUNDAY() + 49

Pentecost Monday = EASTERSUNDAY() + 50

Example

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

=EASTERSUNDAY(2000)+49 returns the internal serial number 36688. The result is 2000-06-11. Format the serial date number as a date, for example in the format YYYY-MM-DD.

Date & Time Functions

DATE

[text/scalc/01/func_datedif.xhp#datedif not found].

DATEVALUE

DAY

DAYS

DAYS360

EASTERSUNDAY

EDATE

EOMONTH

HOUR

[text/scalc/01/func_isoweeknum.xhp#isoweeknum not found].

MINUTE

MONTH

NETWORKDAYS

NETWORKDAYS.INTL

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUM

WEEKNUM_ADD

[text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo not found].

WORKDAY

WORKDAY.INTL

YEAR

YEARFRAC

Please support us!