Microsoft Office Tutorials and References
In Depth Information
Figure 6-6: Using formulas to determine the date for various holidays.
The workbook shown in Figure 6-6, holidays.xlsx, is available at this book's website.
New Year's Day
This holiday always falls on January 1:
=DATE(A1,1,1)
Martin Luther King, Jr. Day
This holiday occurs on the third Monday in January. This formula calculates Martin Luther King, Jr., Day for
the year in cell A1:
=DATE(A1,1,1)+IF(2<WEEKDAY(DATE(A1,1,1)),7-WEEKDAY
(DATE(A1,1,1))+2,2-WEEKDAY(DATE(A1,1,1)))+((3-1)*7)
Presidents' Day
Presidents' Day occurs on the third Monday in February. This formula calculates Presidents' Day for the year in
cell A1:
Search JabSto ::




Custom Search