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.