Microsoft Office Tutorials and References
In Depth Information
Labor Day
Labor Day
Labor Day occurs on the first Monday in September. This formula calculates Labor Day for the year in
cell A1:
=DATE(A1,9,1)+IF(2<WEEKDAY(DATE(A1,9,1)),7-WEEKDAY(DATE(A1,9,1))
+2,2-WEEKDAY(DATE(A1,9,1)))+((1-1)*7)
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