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. |
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) |