Neither of those formulas for Memorial Day (last Monday in May) work
correctly.

A - get the date for the 1st Monday in June
B - subtract 7

=DATE(year,6,8)-WEEKDAY(DATE(year,6,6))-7

--
Biff
Microsoft Excel MVP


<C Gray wrote in message ...
Your Memorial day does not work correctly. Memorial day is always on the
last Monday in May. On occasion it is on the 5th Monday in May. See my
formula below.

=DATE(A3,5,1+(((IF(WEEKDAY(DATE(A3,5,1))=2,IF(WEE KDAY(DATE(A3,5,1))=7,5,4),5))-(2=WEEKDAY(DATE(A3,5,1))))*7)+(2-WEEKDAY(DATE(A3,5,1))))

this one will work correctly.



Posted as a reply to:

U.S. Holidays that the date moves

Here's my post again

Easter day


=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,)*7-6


(by Tomas Jansen), format as date


for US Memorial day


=DATE(A1,5,31)-WEEKDAY(DATE(A1,5,31)-2)


for US Labor Day


=DATE(A1,9,8)-WEEKDAY(DATE(A1,9,6))


for US Thanksgiving


=DATE(A1,11,29)-WEEKDAY(DATE(A1,11,3))



--
Regards,

Peo Sjoblom



"Peo Sjoblom" wrote in message
...

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorials...vices-usi.aspx