For thanksgiving put the year in A1 and this formula in a cell

=DATE(A1,11,1+((4-(5=WEEKDAY(DATE(A1,11,1))))*7)+(5-WEEKDAY(DATE(A1,11,1))))

Mike

"top.jimmy" wrote:

What am I missing here to calculate Thanksgiving Day which is the 4th
Thursday of the month of November? How do I write DoW?:

=DATE(YEAR(NOW()),11,1+((4th-(DoW=WEEKDAY(DATE(YEAR(NOW()),11,1))))*7)+(DoW-WEEKDAY(DATE(YEAR(NOW()),11,1))))

"Mike H" wrote:

Jim

Chip Pearson has done it.

http://www.cpearson.com/excel/holidays.htm

Mike

"top.jimmy" wrote:

Are there Excel (not VB or VBA) formulas already posted that will give the
dates of Easter Sunday, Memorial Day, Labor Day, and Thanksgiving Day every
year? A perpetual formula for each so to speak.
New Years, Christmas, Valentine's, St. Patrick's, & Independence Days, etc.
are easy. They never change.

Anyone who has gone down this road and would like to share their efforts, I
would appreciate it!!!
JIM