|
<< Click to Display Table of Contents >> HOLIDAY (dates of movable Christian holidays) |
Syntax:
HOLIDAY(Year, Type)
Description:
This returns the date of the movable Christian holidays in the specified year.
Year is the desired year (as an integer).
Type is an integer that determines the holiday for which the date should be returned:
0: Good Friday
1: Easter Sunday
2: Easter Monday
3: Ascension Day
4: Whit Sunday (Pentecost)
5: Whit Monday
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()), 5) returns the date of Whit Monday in the current year
Compatibility notes:
This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.
See also: