|
<< Click to Display Table of Contents >> HOLIDAY (dates of movable Christian holidays) |
Syntax:
HOLIDAY(Year, Type)
Description:
Returns the date of the specified movable Christian holiday in the given year.
Year is an integer number that specifies the year to evaluate.
Type is an integer number that specifies which holiday to calculate, as follows:
0: Good Friday
1: Easter Sunday
2: Easter Monday
3: Ascension Day
4: Whitsunday (Pentecost)
5: Whitmonday
6: (Feast of) Corpus Christi
7: Ash Wednesday
8: Repentance Day (Germany)
9: 1st Sunday of Advent
Example:
HOLIDAY(2014, 1) returns 04/20/2014 (Easter Sunday in 2014)
HOLIDAY(YEAR(TODAY(), 1) returns the date of Easter Sunday in the current year
Compatibility notes:
This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.
See also: