TODAY function

[Connie]

I have a macro for inserting the last business day, but
it's not exactly true because, if you live in the US or
Canada, the last business day was Friday, August 29th, and
this macro is giving me yesterday, Monday, September 1,
which was a holiday. The formula in the macro is this:

=TODAY()-CHOOSE(WEEKDAY(TODAY()),2,3,1,1,1,1,1)

Is there anything I can add to this formula, or is there
another formula that when I run the macro today it gives
me August 29 as the last business day?

Thank you
Connie

 

[Connie]

I am just getting a chance now to look at this. I copied
your formula but it doesn't seem to work. It returns
#NAME?

Connie

 

[Rick C]

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

 

[Connie]

Thank you! It works now. Have a nice day!

Connie