Need help with a date function formula

[KAA]

I have an excel sheet header which includes a date, the date is t
represent yesterday's date ( =Today()-1 ), which then would come int
the spread sheet as August 8th, 2005, assuming today was August 9th.
The problem is on days like Monday when the previous day was sunday
how can I make the formula output the Friday before the Monday instea
of Sunday ...example on Monday, August 11th, the formula would read
August 10th, I need it to read August 8th...? Please help, thank

 

[Domenic]

Try...

=WORKDAY(TODAY(),-1)

....which requires that the Analysis ToolPak be enabled...

Tools > Add-Ins > and check Analysis ToolPak

Hope this helps!

 

[David Hepner]

Try this:

=IF(WEEKDAY(NOW()-1)=1,(NOW()-3),NOW()-1)