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:
=DATE(A1,2,1)+IF(2<WEEKDAY(DATE(A1,2,1)),7-WEEKDAY
(DATE(A1,2,1))+2,2-WEEKDAY(DATE(A1,2,1)))+((3-1)*7)

Memorial Day
The last Monday in May is Memorial Day. This formula calculates Memorial Day for the year in cell A1:
=DATE(A1,6,1)+IF(2<WEEKDAY(DATE(A1,6,1)),7-WEEKDAY
(DATE(A1,6,1))+2,2-WEEKDAY(DATE(A1,6,1)))+((1-1)*7)-7

Notice that this formula actually calculates the first Monday in June and then subtracts 7 from the result to return the last Monday in May.

Independence Day
This holiday always falls on July 4:
=DATE(A1,7,4)

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)

Veterans Day
This holiday always falls on November 11:
=DATE(A1,11,11)

Columbus Day
This holiday occurs on the second Monday in October. This 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)

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
This holiday always falls on December 25:
=DATE(A1,12,25)

• Dating and Gift Giving: What to do? ======================================= Dating and Gift Giving: What to do ======================================= What are the best types of gifts to give to someone...
• 2009 Individual Stimulus Money Worth More Than Last Year's Package. Good idea or not, President Obama's individual economic stimulus package is worth more to each person than the last one...
• OK, be honest now, who's going to see Indy? Count us in. We are going. I'm not sure if we will take the 12 and 10 year olds, but...
• Excel How-to: A Macro to Hide Blank Rows on a Spreadsheet Today, a coworker asked me how to hide a row on his Excel spreadsheet.  This was a fairly large spreadsheet,...
• Calculating Interest On Loans My father was gracious enough to use his Home Equity Line of Credit to pay my 6.8% student loan, and...