ASHWEDNESDAY Function (Gnumeric)

• Introduced: Gnumeric 1.9.15. The official 1.9.14-to-1.9.15 source diff adds the Christian-date implementation and registers all five named functions; the release notes identify the new calendar group. No exact release day is inferred from an archive timestamp.
• Documented support: Registered in the Christian Date Functions plugin for Gnumeric 1.12.62. No retirement is established.
• Last functioning version: Unverified; source support does not prove application execution.
• Evidence dates: The 1.12.62 source snapshot was retained October 13–14, 2026. The historical release diff and notes were retrieved October 15; calculations and this full guide were reviewed that day. No native Gnumeric or GUI test was run.

ASHWEDNESDAY returns the Gregorian date identified by Gnumeric’s Roman-rite calendar, calculated as Easter Sunday minus 46 calendar days. The offset is an ordinary date difference. Do not replace it with minus 40 merely because another description uses a different counting convention. This function does not calculate a country-specific public-holiday entitlement or an organizational closure.

=ASHWEDNESDAY([year])

The single numeric year argument is optional. With an explicit year, the shared helper converts it to an integer and applies Gnumeric’s year adjustment: 0–29 become 2000–2029, while 30–99 become 1930–1999. Thus 29 and 30 differ by nearly a century, not by one year. Use four-digit years for an auditable calendar. Negative integer years and years above 9956 return #NUM!.

The help states a nominal lower bound of 1582, but actual acceptance depends on date conventions and whether negative dates are enabled. The year-adjustment helper can reject years before the workbook’s 1900 or 1904 base. The modern worked years avoid this setting-dependent region. Blank and text coercions are unverified; an omitted argument is a deliberate separate operation.

Create AshYears with years 2024, 2025, 2026, 2027 and 2028 in A2:A6. Fill B2 =ASHWEDNESDAY(A2) through B6. Expected dates are February 14, 2024; March 5, 2025; February 18, 2026; February 10, 2027; and March 1, 2028. Put =EASTERSUNDAY(A2) in C2 and =C2-B2 in D2, then fill both down. Every expected D result is 46, including years that cross February 29.

These ISO dates make the expected calendar result unambiguous. A workbook can display a different localized date format without changing the underlying date. The table does not specify a date-system-dependent serial number.

For a preparation checklist, put year 2026 in B2, =ASHWEDNESDAY(B2) in B3, =B3-7 in B4 and =B3+7 in B5. The expected anchor is February 18, with preparation on February 11 and review on February 25. These offsets are explicit project choices, not alternative calendar definitions. Their date differences from the anchor are both seven days.

Change only B2 to 2028 in a copy. The anchor becomes March 1; the preceding week is February 23 and the following week March 8. That test crosses leap-year February and exposes a fragile hand-built rule that assumes February always has 28 days. Keep the year and calculated anchor separate from display labels so the dependency remains visible. Comparing =ASHWEDNESDAY(B2)=EASTERSUNDAY(B2)-46 should give TRUE for these modern-date fixtures.

The no-year helper reads the current system time, derives the calendar year and computes this specific holiday. It advances to next year only when this year’s holiday is strictly before the date being evaluated. Therefore the current holiday date itself is included in “next”; it does not automatically skip to next year on that day.

For a hypothetical evaluation date of 2026-02-17, =ASHWEDNESDAY() has reference date 2026-02-18. On 2026-02-18, it still has that date. On 2026-02-19, it changes to 2027-02-10. These are simulated clock inputs to the source rule, not observations of today’s application output. The functions are registered as volatile; actual recalculation timing, timezone handling and saved-workbook caching were not tested.

The year omitted by ASHWEDNESDAY is chosen using the Ash Wednesday date, not the Easter date. On February 19, 2026 the no-argument rule has already moved to 2027’s Ash Wednesday, even though Easter 2026 is still ahead. This source-backed distinction prevents an incorrect assumption that all five no-argument Christian-date functions must currently choose the same year.

If the output looks like an integer, inspect the cell’s date format before changing the formula. If a year is rejected, inspect the four-digit input and the workbook’s date conventions. Do not repair an unsupported date by silently changing the requested year. The shared implementation includes a correction for negative offsets crossing the fictitious February 29, 1900 serial-date gap; the simple date-offset worksheet identities above are claimed for the stated modern years, not every historical serial boundary.

Check exact function spelling and the Christian Date Functions plugin when resolving availability issues. This guide does not supply a tested plugin-installation workflow. Error displays for malformed expressions, locale-specific entry, external workbook import and extreme serial values are unverified. The explicit-year controls and hypothetical-clock controls serve different purposes and should be kept separate.

• Function-specific help
• Worksheet callback and exact calendar offset
• Shared Easter algorithm and serial conversion
• Gnumeric official function catalogue

EASTERSUNDAY, GOODFRIDAY, DATE.