EASTERSUNDAY Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with the limitations described here; no retirement established.
• Scope: Desktop Sheets with the Date & Time module. Formulas use English names and semicolon separators.
• Checked: October 14, 2026: selected 25.04.2 engine-library formulas and independent calendar/time reconstructions; 26.08.2 source only. The test locale was C, with Monday as its week start. No GUI-cell or import execution is claimed.

EASTERSUNDAY calculates the Gregorian Easter Sunday date for the supplied year. Its returned value is a date-formatted serial. The engine harness reports that serial numerically; the calendar interpretation below is independently calculated rather than a claim about GUI formatting. This is the Gregorian calculation, not an Eastern Orthodox or other-calendar algorithm. Official function reference.

=EASTERSUNDAY(year)

year is the one required argument. Use a valid positive integer calendar year. The converter floors fractional values, so 2025.9 was treated as 2025. Numeric text “2025” was accepted in the tested case; this does not establish support for arbitrary text or every year range. Registration and implementation.

Numeric results are rounded here to twelve decimal places. The reconstruction column applies independent calendar arithmetic or the explicitly inspected time/conversion rule. Date serials use the tested default reference date; they do not show native GUI date formatting.

Calendar interpretation of the date results

Put 2025 in A2 and use =EASTERSUNDAY(A2) in B2. The computed date is April 20, 2025, represented by serial 45767 under the tested December 30, 1899 reference date. Choose a date display format in a worksheet if you want a readable date; the tests here did not exercise that GUI formatting operation.

A holiday worksheet can keep the year, computed date and a descriptive label in separate columns. The function calculates one religious-calendar date; it does not automatically supply local public holidays, observed-day substitutions or working-day rules.

The following expression extracts year, month and day into the integer 20250420. It was executed through the same engine and independently checked against Gregorian Easter arithmetic. This provides a reproducible date identity without relying on a locale-specific display string.

The eight reference years include the March 22 extreme in 1818 and April 25 in 1943. These are tested examples, not a claim that all historical or future date conventions have been validated.

=YEAR(EASTERSUNDAY(2025))*10000+MONTH(EASTERSUNDAY(2025))*100+DAY(EASTERSUNDAY(2025))

The executed result was 20250420.

Invalid input conversion is not reliably signaled by an error. The tested “abc” and division-by-zero arguments both produced numeric zero, which can be mistaken for a date near the reference epoch. TRUE converted to year 1 and produced a very early date serial. Reject those inputs rather than interpreting a plausible numeric value as validation. The zero-argument and two-argument calls returned actual #VALUE! errors. Broad out-of-range and negative-year behavior was not tested.

• Function-specific implementation
• Versioned help
• Integer Conversion
• Integer Floor
• Reference Date
• Date Constructor
• Default Arity

The selected callbacks, date/time module and inspected conversion/time helpers are byte-identical between the retained 25.04.2 and 26.08.2 sources. This establishes source continuity for the described paths, not execution of the later release.

DATE, YEAR, WEEKDAY.