Documentation/Calc Functions/EASTERSUNDAY

From The Document Foundation Wiki
Jump to navigation Jump to search

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 Tools > Options > LibreOffice > General 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).

Additional details:

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

General information about Calc's Date and Time functions

Note pin.svg

For convenience the information in this subsection is repeated on all pages that describe functions in the Date and Time category.


  • Internal to Calc, a date/time value is handled as a real number and this is sometimes referred to by the term date-time serial number. For example, 2021-02-08 12:00:00 corresponds to the date-time serial number 44235.5. The integer part of a date-time serial number (before the decimal point) is the number of days since a defined start date. The fractional part of a date-time serial number (after the decimal point) is the time of day expressed as a fraction of a day. For example, 0.25 is equivalent to 06:00:00 and 0.75 is equivalent to 18:00:00.
  • Calc uses 1899-12-30 as the default start date (day 0) but you can go to Tools > Options > LibreOffice Calc > Calculate to select alternative start dates; however, unless you have specific requirements for compatibility with legacy spreadsheet applications, we recommend that you do not change this setting. If you copy and paste cells containing date values between different spreadsheets, check that both documents are set to use the same start date to avoid unexpected changes to the dates displayed.
  • Negative date-time serial numbers correspond to dates earlier than Calc's start date. Calc calculates all dates back to 15th October 1582 using the Gregorian calendar. The day before this is 4th October 1582, and Calc uses the Julian calendar for earlier dates.
  • A date-time serial number is the same as any other number, except that we usually choose to display it formatted as a date/time. You can enter a number in a cell and then change the cell’s formatting to display the value as a date/time. You can also enter a date/time in a cell and then change the cell’s formatting to display the date-time serial number.
  • For clarity, the descriptions of the Calc functions within these wiki pages use the standard ISO 8601 format for date and time because this should be independent of your selected locale settings. The default date format on your computer may be different. When entering dates as part of formulas, slashes or dashes used as date separators may be interpreted as arithmetic operators. Therefore, dates entered in this format are not recognized as dates and result in erroneous calculations. To keep dates from being interpreted as parts of formulas either use the DATE function or place the date in quotation marks and use the ISO 8601 notation. Avoid using locale dependent date formats which may produce errors if the document is loaded under different locale settings.
  • Time zone information is not used by Calc’s Date & Time functions.
  • If you only wish to enter two digits of the year (for example 21 instead of 2021), Calc needs to know whether you mean 2021 or 1921. Go to Tools > Options > LibreOffice > General to view or adjust the range of years which Calc will use to interpret two-digit year values.
  • Calc contains logic to decide how to treat text when encountered as an operand in an arithmetic operation or as an argument to a function that expects a number instead. In this context, unambiguous conversion is possible for ISO 8601 dates and times in their extended formats with separators. For example, the simple formula =1 + "2021-02-08" will usually give the result 2021-02-09 (when formatted as a date). However, this logic may be affected by the settings on the Detailed Calculation Settings dialog, accessed by selecting Tools > Options > LibreOffice Calc > Formula and pressing the Details button in the Detailed Calculation Settings area. If a #VALUE! error occurs, it may be because the Generate #VALUE! error option is selected, in which case you should experiment with one of the other self-explanatory options in the Conversion from text to number drop-down.

Examples:

Formula Description Returns
=EASTERSUNDAY(2021) Here the function returns the date-time serial number for the date of Easter Sunday in 2021 (44290). By default, this will be formatted as a date (2021-04-04). 2021-04-04
=EASTERSUNDAY(19) Assuming that LibreOffice has been configured to convert two-digit years in the range 1930 to 2029, the function returns the date-time serial number for the date of Easter Sunday in 2019 (43576). By default, this will be formatted as a date (2019-04-21). 2019-04-21
=EASTERSUNDAY(G4) where cell G4 contains the value 2000. Here the function returns the date-time serial number for the date of Easter Sunday in 2000 (36639). By default, this will be formatted as a date (2000-04-23). 2000-04-23
=EASTERSUNDAY(2021)+49 Here the function returns the date-time serial number for the date of Pentecost Sunday in 2021 (44339). By default, this will be formatted as a date (2021-05-23). 2021-05-23

Related LibreOffice functions:

None.

ODF standard:

None.

Equivalent Excel functions:

None.