The formula you quoted is far too big,


with the year question in A1


Easter day


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


by Tomas Jansen, format as date


for 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

"top.jimmy" wrote in message
...
What did you come up with for Memorial Day, Thanksgiving Day, and Labor
Day?
I'm working on something similar and could use your expertise.

Thanks,
JIM