labor day holiday formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
You already have plenty of answers in the previous thread.,

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Is that right Bob! So they work? I can't seem to make them work with may last
suggestion. Please advise me!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Labor day formula 3
New Years Day formula? 3
Formula Help 4
Need calendar form to display holidays 1
Holidays 9
Works Calendar in 9.0 1
vacation excluding holidays 1
Calculate Holiday 2

Back
Top