Documentation/Calc Functions/EASTERSUNDAY/en

Function name:
EASTERSUNDAY

Category:
Date and Time

Summary:
Calculates the date of Easter Sunday in a specified year in the Gregorian calendar. This date will always lie between 22nd March and 25th April of that year.

Syntax:
EASTERSUNDAY(Year)

Returns:
Returns an integer date-time serial number which represents the date of Easter Sunday for the year passed as an argument. The returned value is formatted as a date by default, but you can apply other formats as needed.

Arguments:
Year is a non-negative integer value, or a reference to a cell containing that value, which is the year to be used. Values in the range 0 to 99 are converted to four-digit years in accordance with the Year (Two Digits) setting on the dialog. However, to avoid confusion it is better to always use four-digit years.


 * If Year is non-numeric, then EASTERSUNDAY reports a #VALUE! error.
 * If Year is a non-integer value, then the function truncates it to an integer.
 * Year must be a number either in the range 0 to 99 (inclusive) or in the range 1583 to 9956 (inclusive). If the value of Year is not within either of these ranges, then EASTERSUNDAY reports an invalid argument error (Err:502).

Details specific to EASTERSUNDAY function
EASTERSUNDAY is not part of the ODF 1.2 international standard and should not be regarded as portable.

For more information about calculating the calendar date of Easter, view Wikipedia’s Computus page.

You can also calculate dates of other holidays by simple addition of appropriate offsets to the date of Easter Sunday.
 * Easter Monday = EASTERSUNDAY(Year) + 1
 * Good Friday = EASTERSUNDAY(Year) - 2
 * Pentecost Sunday = EASTERSUNDAY(Year) + 49
 * Pentecost Monday = EASTERSUNDAY(Year) + 50

Related LibreOffice functions:
None.

ODF standard:
None.

Equivalent Excel functions:
None.