EASTERSUNDAY

āĻĒā§āϰāĻŦ⧇āĻļāĻŋāϤ āĻŦāĻ›āϰ⧇āϰ āϜāĻ¨ā§āϝ āχāĻ¸ā§āϟāĻžāϰ āϏāĻžāύāĻĄā§‡ āĻāϰ āϤāĻžāϰāĻŋāĻ– āĻĒā§āϰāĻĻāĻžāύ āĻ•āϰ⧇āĨ¤

Syntax

EASTERSUNDAY(Year)

āĻŦāĻ›āϰ āĻšāϞ⧋ ā§§ā§Ģā§Žā§Š āĻāĻŦāĻ‚ ⧝⧝ā§Ŧā§Ģ āĻ…āĻĨāĻŦāĻž ā§Ļ āĻāĻŦāĻ‚ ⧝⧝ āĻāϰ āĻŽāĻ§ā§āϝāĻŦāĻ°ā§āϤ⧀ āĻāĻ•āϟāĻŋ āĻĒā§‚āĻ°ā§āĻŖ āϏāĻ‚āĻ–ā§āϝāĻžāĨ¤ āφāĻĒāύāĻŋ āĻ…āĻ¨ā§āϝ āϛ⧁āϟāĻŋāϰ āĻĻāĻŋāύāϗ⧁āϞāĻŋ āϤāĻžāϰāĻŋāϖ⧇āϰ āϏāĻžāĻĨ⧇ āϏāĻžāϧāĻžāϰāĻŖ āϏāĻ‚āϝ⧁āĻ•ā§āϤāĻŋāϰ āĻŽāĻžāĻ§ā§āϝāĻŽā§‡ āĻ—āĻŖāύāĻž āĻ•āϰāϤ⧇ āĻĒāĻžāϰ⧇āύāĨ¤

Easter Monday = EASTERSUNDAY(Year) + 1

Good Friday = EASTERSUNDAY(Year) - 2

Pentecost Sunday = EASTERSUNDAY(Year) + 49

Pentecost Monday = EASTERSUNDAY(Year) + 50

Example

=EASTERSUNDAY(2000) returns 2000-04-23.

=EASTERSUNDAY(2000)+49 returns the internal serial number 36688. The result is 2000-06-11. Format the serial date number as a date, for example in the format YYYY-MM-DD.

Technical information

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

ORG.OPENOFFICE.EASTERSUNDAY

Date & Time Functions

DATE

[text/scalc/01/func_datedif.xhp#datedif not found].

DATEVALUE

DAY

DAYS

DAYS360

EASTERSUNDAY

EDATE

EOMONTH

HOUR

[text/scalc/01/func_isoweeknum.xhp#isoweeknum not found].

MINUTE

MONTH

NETWORKDAYS

NETWORKDAYS.INTL

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUM

WEEKNUM_ADD

[text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo not found].

WORKDAY

WORKDAY.INTL

YEAR

YEARFRAC

Please support us!