Microsoft Office Tutorials and References
In Depth Information
Columbus Day
Columbus Day
The Columbus Day holiday occurs on the second Monday in October. The following formula
calculates Columbus Day for the year in cell A1:
=DATE(A1,10,1)+IF(2<WEEKDAY(DATE(A1,10,1)),7-WEEKDAY(DATE(A1,10,1))
+2,2-WEEKDAY(DATE(A1,10,1)))+((2-1)*7)
Veterans Day
The Veterans Day holiday always falls on November 11:
=DATE(A1,11,11)
Thanksgiving Day
Thanksgiving Day is celebrated on the fourth Thursday in November. This formula calculates
Thanksgiving Day for the year in cell A1:
=DATE(A1,11,1)+IF(5<WEEKDAY(DATE(A1,11,1)),7-WEEKDAY(DATE(A1,11,1))
+5,5-WEEKDAY(DATE(A1,11,1)))+((4-1)*7)
Christmas Day
Christmas Day always falls on December 25:
=DATE(A1,12,25)
 
Search JabSto ::




Custom Search