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