EASTERSUNDAY in Collabora Office: Generate Easter Dates and Related Holidays

=EASTERSUNDAY(Year)

Year is required. Collabora’s function help specifies an integer in 1583–9956 or 0–99. The dedicated section does not explain how the two-digit range is mapped to centuries, so use an explicit four-digit year in a reproducible workbook.

The function returns a date value, not a text label or a holiday calendar. Arithmetic offsets can derive dates relative to Easter Sunday. Whether a resulting date is an observed public holiday or a nonworking day depends on the calendar you actually follow.

The documented example is =EASTERSUNDAY(2000), returning 2000-04-23. That fixed control is useful when checking an installation or an imported workbook.

Enter the numeric years below into A2:A5. In B2 enter =EASTERSUNDAY(A2) and fill down. Apply a date format such as YYYY-MM-DD to B2:B5.

These are independently calculated calendar targets, not native Collabora observations. Store the year as the number 2026, not a date serial for January 1, 2026. Supplying a whole date where the function expects a year is a different input.

If B4 displays an integer, change only its number format first. Replacing a valid date value with manually typed text makes later date arithmetic harder to audit.

The help documents these offsets from Easter Sunday:

The additions are calendar-day offsets, not working-day offsets. For example, adding one to Easter Sunday gives Monday directly; it does not inspect weekends or a list of closures.

As a second documented control, the vendor’s =EASTERSUNDAY(2000)+49 corresponds to 2000-06-11, and its example serial is 36688. Prefer the displayed date when comparing workbooks because a serial number is meaningful only with the workbook’s date system.

For year 2026 in F1, place these formulas in F3:F5:

=EASTERSUNDAY($F$1)-2
=EASTERSUNDAY($F$1)+1
=EASTERSUNDAY($F$1)+50

The independent dates are April 3, April 6, and May 25, 2026. Add labels in E3:E5 and date formatting in F3:F5. This creates a reusable date list without manually retyping next year’s dates.

A NETWORKDAYS or WORKDAY calculation can use a holiday range when its documented arguments allow one. Include only closures actually relevant to your schedule. This function does not establish which observances apply to a country, employer, or religious tradition, and it does not automatically substitute an observed weekday.

Use integer years inside the documented range. The section does not establish how fractional years, invalid strings, or out-of-range years are coerced or which precise native error they produce. Do not use the two-digit input range when century interpretation matters.

Keep all derived cells in date format, and verify a known control before building a long schedule. DATE helps create independent comparison dates without ambiguous text parsing.

The vendor identifies EASTERSUNDAY as outside OpenDocument 1.3 OpenFormula and gives the namespace ORG.OPENOFFICE.EASTERSUNDAY. This namespace is a file-format identifier, not a guarantee that other spreadsheet programs calculate or preserve the function. The reviewed help does not establish other religious-calendar variants or a selectable calendar argument.

The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.

The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.

• Collabora Office 26.04: EASTERSUNDAY (checked October 17, 2026).
• Editorial testing standards.