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