Dynamic date

[Stephen Rammer]

Hi,

I am looking for an automatic way to show a date in
Excel, which is always equal to the business day before
the current date. "Now()-1" will work for the last 4 days
during the week. However, my problem is on Mondays. I need
the date to show Friday and not Sunday. Any ideas?

 

[Frank Kabel]

Hi
try
=WORKDAY(NOW(),-1)

 

[Tom Ogilvy]

If you don't want to install the analysis toolpak,

=if(weeday(today())=2,today()-3,today()-1)