You already have plenty of answers in the previous thread.,

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Richard" wrote in message
...
Since Labor day fall on the first Monday in September and I'm using this
formula to calculate the last Monday in May for Memorial day. How can I
write
a new formula for September?
=NDOW(TheYear, 5,DowsInMonth(TheYear,5,2), 2)
Thanks in advance!!!