OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

# office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] (OFFICE-2164) Add EASTERSUNDAY function

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Sun, 24 Apr 2022 21:16:00 +0000 (UTC)

```     [ https://issues.oasis-open.org/browse/OFFICE-2164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Francis Cave updated OFFICE-2164:
---------------------------------
Resolution:
h3. 6.10.8 EASTERSUNDAY

*Summary:* Returns the date of Easter Sunday in the Gregorian Calendar in {color:#610506}_*Year*_{color} if given, otherwise returns the date of the next Easter Sunday on or after TODAY().
{quote}*Note:* The use of the Gregorian calendar was introduced in different locations at different times.
{quote}
*Syntax:* EASTERSUNDAY( [Â_{color:#5c2d91}Integer{color}_ {color:#610506}_*Year*_{color}Â] )

*Returns:* _{color:#5c2d91}Date{color}_

*Constraints:* 1582 â {color:#610506}_*Year*_{color} â 9956

*Semantics:* Given an integer value for Year in the allowed range, the Easter Sunday date is calculated according to the following algorithm:
{code:java}
A1 = INT(Year/100)
A2 = Year-19*INT(Year/19)
A3 = INT((A1-17)/25)
A4 = MOD(A1-INT(A1/4)-INT((A1-A3)/3)+19*A2+15;30)
A5 = A4-INT(A4/28)*(1-INT(A4/28)*INT(29/(A4+1))*INT((21-A2)/11))
A6 = MOD(Year+INT(Year/4)+A5+2-A1+INT(A1/4);7)
A7 = A5-A6
month = 3+INT((A7+40)/44)
day = A7+28-31*INT(month/4)
{code}
The resulting date is: DATE({{Year}}; {{month}}; {{day}}).

If {color:#610506}_*Year*_{color} is not given, the above calculation is performed for the current and the next year, and the smaller of the two dates that is not less than TODAY() is returned.

was:
h3. 6.10.8 EASTERSUNDAY

*Summary:* Returns the date of Easter Sunday in the Gregorian Calendar in {color:#610506}_*Year*_{color} if given, otherwise returns the date of the next Easter Sunday on or after TODAY().

{quote}*Note:* The use of the Gregorian calendar was introduced in different locations at different times.{quote}

*Syntax:* EASTERSUNDAY( _{color:#5c2d91}Integer{color}_ {color:#610506}_*Year*_{color} )

*Returns:* _{color:#5c2d91}Date{color}_

*Constraints:* 1582 â {color:#610506}_*Year*_{color} â 9956

*Semantics:* Given an integer value for Year in the allowed range, the Easter Sunday date is calculated according to the following algorithm:
{code:java}
A1 = INT(Year/100)
A2 = Year-19*INT(Year/19)
A3 = INT((A1-17)/25)
A4 = MOD(A1-INT(A1/4)-INT((A1-A3)/3)+19*A2+15;30)
A5 = A4-INT(A4/28)*(1-INT(A4/28)*INT(29/(A4+1))*INT((21-A2)/11))
A6 = MOD(Year+INT(Year/4)+A5+2-A1+INT(A1/4);7)
A7 = A5-A6
month = 3+INT((A7+40)/44)
day = A7+28-31*INT(month/4)
{code}
The resulting date is: DATE({{Year}}; {{month}}; {{day}}).

If {color:#610506}_*Year*_{color} is not given, the above calculation is performed for the current and the next year, and the smaller of the two dates that is not less than TODAY() is returned.

> -------------------------
>
>                 Key: OFFICE-2164
>                 URL: https://issues.oasis-open.org/browse/OFFICE-2164
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: New Feature
>          Components: OpenFormula, Part 2 (Formulas)
>            Reporter: Eike Rathke
>            Assignee: Patrick Durusau
>            Priority: Minor
>             Fix For: ODF 1.4
>
>
> OpenOffice.org Calc knows the EASTERSUNDAY function, this is a proposal to include that with OpenFormula.

--
This message was sent by Atlassian Jira
(v8.3.3#803004)
```

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]