Need help with a date function formula

[KAA]

I have an excel sheet header which includes a date, the date is to represent yesterday's date ( =Today()-1 ), which then would come into 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 instead of Sunday ...example on Monday, August 11th, the formula would read August 10th, I need it to read August 8th...? Please help, thanks

[Domenic]

Try...

=WORKDAY(TODAY(),-1)

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

Tools > Add-Ins > and check Analysis ToolPak

Hope this helps!

In article <[email protected]>,
KAA <[email protected]> wrote:

> I have an excel sheet header which includes a date, the date is to
> represent yesterday's date ( =Today()-1 ), which then would come into
> 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 instead
> of Sunday ...example on Monday, August 11th, the formula would read
> August 10th, I need it to read August 8th...? Please help, thanks

[David Hepner]

Try this:

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

"KAA" wrote:

>
> I have an excel sheet header which includes a date, the date is to
> represent yesterday's date ( =Today()-1 ), which then would come into
> 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 instead
> of Sunday ...example on Monday, August 11th, the formula would read
> August 10th, I need it to read August 8th...? Please help, thanks
>
>
> --
> KAA
> ------------------------------------------------------------------------
> KAA's Profile: http://www.excelforum.com/member.php...o&userid=26755
> View this thread: http://www.excelforum.com/showthread...hreadid=400071
>
>