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