The one I posted to was one of those strange things where it seems he posted
to an old post from 2006 which you btw took part in (I noticed that after I
posted my answer).

http://tinyurl.com/2gfale

if you scroll to the top you will find yourself in that thread from Nov 2006
<g

Peo


"T. Valko" wrote in message
...
How many posts are there?

I posted formulas for Labor Day and Memorial day at one of his threads in
.excel.


--
Biff
Microsoft Excel MVP


"Peo Sjoblom" wrote in message
...
Day of the week

If you check your other post I posted formulas for Easter, Memorial,
Labor and Thanksgiving


--
Regards,

Peo Sjoblom



"top.jimmy" wrote in message
...
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