labor day holiday formula

[Richard]

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!!!

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[Richard]

Is that right Bob! So they work? I can't seem to make them work with may last
suggestion. Please advise me!