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

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

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


Subject: more about EASTERSUNDAY


Just for your information, Gnumeric 1.9.15 includes the following
functions. (Of course Gnumeric has lots of functions that are not
included in the current OpenFormula draft.) Note that while in first
glance it may seem that may of these are just fixed offsets from
EasterSunday, the interpretation of an omitted year, changes that: the
dat for GOODFRIDAY() may be in the year following the date for
EASTERSUNDAY or not., since both refer to the next such holiday.

------------------------------------------------------------------

ASCENSIONTHURSDAY: Ascension Thursday in the Gregorian calendar
according to the Roman rite of the Christian Church

Arguments:
year: year between 1582 and 9956, defaults to the year of the next
Ascension Thursday

ASHWEDNESDAY: Ash Wednesday in the Gregorian calendar according to the
Roman rite of the Christian Church

Arguments:
year: year between 1582 and 9956, defaults to the year of the next Ash
Wednesday

EASTERSUNDAY: Easter Sunday in the Gregorian calendar according to the
Roman rite of the Christian Church

Arguments:
year: year between 1582 and 9956, defaults to the year of the next
Easter Sunday

GOODFRIDAY: Good Friday in the Gregorian calendar according to the Roman
rite of the Christian Church

Arguments:
year: year between 1582 and 9956, defaults to the year of the next Good
Friday

HDATE: Hebrew date

Arguments:
year: year of date
month: month of year
day: day of month

Examples:
hdate(2001,3,30) evaluates to "6 Nisan 5761".

HDATE_DAY: Hebrew day of Gregorian date

Arguments:
year: Gregorian year of date
month: Gregorian month of year
day: Gregorian day of month

Examples:
hdate_day(2001,3,30) evaluates to 6.

HDATE_HEB: Hebrew date in Hebrew

Arguments:
year: year of date
month: month of year
day: day of month

Examples:
hdate_heb(2001,3,30) evaluates to "ו'\" ניסן התשסא".

HDATE_JULIAN: Julian day number for given Gregorian date

Arguments:
year: Gregorian year of date
month: Gregorian month of year
day: Gregorian day of month

HDATE_MONTH: Hebrew month of Gregorian date

Arguments:
year: Gregorian year of date
month: Gregorian month of year
day: Gregorian day of month

HDATE_YEAR: Hebrew year of Gregorian date

Arguments:
year: Gregorian year of date
month: Gregorian month of year
day: Gregorian day of month

PENTECOSTSUNDAY: Pentecost Sunday in the Gregorian calendar according to
the Roman rite of the Christian Church

Arguments:
year: year between 1582 and 9956, defaults to the year of the next
Pentecost Sunday

------------------------------------------------------------------

Andreas
-- 
Andreas J. Guelzow
Concordia University College of Alberta



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