Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
labor day holiday formula
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!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
labor day holiday formula
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!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
labor day holiday formula
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" 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |