Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Public Holidays
Hi,
Please help. Currently I have a formula in my macro with the below logic. If today is workday (Mon) then = today -3 If today is workday (Tues to Friday) then = today-1 If today is Weekend (Sat) then = today - 1 If today is Weekend (Sun) then = today -2 The problem I have is when there's a public holiday. How do I account for a public holiday? How can I store the public holidays within the macro? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Public Holidays
Maybe you could just use =workday() from the analysis toolpak (tools|addins to
install it). And you could put the holidays in a column on a (hidden?) worksheet. (Maybe you won't need a macro.) But you could store the list of holidays on a worksheet and still use them in your code, too. missk wrote: Hi, Please help. Currently I have a formula in my macro with the below logic. If today is workday (Mon) then = today -3 If today is workday (Tues to Friday) then = today-1 If today is Weekend (Sat) then = today - 1 If today is Weekend (Sun) then = today -2 The problem I have is when there's a public holiday. How do I account for a public holiday? How can I store the public holidays within the macro? Thank you. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Holidays | Excel Worksheet Functions | |||
Considering Holidays | Excel Programming | |||
holidays | Excel Discussion (Misc queries) | |||
Holidays | Excel Worksheet Functions | |||
Account for Public Holidays | Excel Discussion (Misc queries) |