Re: [office-formula] OFFICE-2164: EASTERSUNDAY

[robert_weir@us.ibm.com]

I'm looking at this from a "linguistic and cultural adaptability" 
perspective, which is an ISO/IEC requirement.  There are two dates where 
Easter is celebrated, if you consider as well the Eastern Orthodox 
observance.  And then there are all the other holidays which have movable 
dates in various religions and cultures which base such dates on a lunar 
calendar.

I wonder whether the approach is to have a function called HOLIDAY(String 
name, Number year), which you could call as:

HOLIDAY("Easter", 2009)

or 

HOLIDAY("Easter-Orthodox", 2009)

or

HOLIDAY("Passover", 2010)

We could reserve strings for the major observances and then allow 
implementation-defined extensions.

-Rob


Eike Rathke <erack@sun.com> wrote on 10/26/2009 11:28:12 AM:

> 
> http://tools.oasis-open.org/issues/browse/OFFICE-2164
> 
> I propose to define the EASTERSUNDAY function.
> 
> Any objections?
> 
>   Eike
> 
> --