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:
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:
Presidents' Day occurs on the third Monday in February. This formula calculates Presidents' Day for the year in