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" <[email protected]> wrote in message
news:[email protected]...
> 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!!!

[Richard]

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

"Bob Phillips" wrote:

> You already have plenty of answers in the previous thread.,
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Richard" <[email protected]> wrote in message
> news:[email protected]...
> > 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!!!
>
>
>