Date, Weekdays

Hi!

Could you please help me with date formula.

I need to enter 2 days before but it must be a weekday.
e.g 12 Sep 2005 must show 9 Sep 2005 and also 13 Sep 2005 must show 9 Sep 2005.

What I have is NOW()-2 , but it shows 10 Sep 2005 which is wrong.

"Heckstein" wrote:

>
> Hi!
>
> Could you please help me with date formula.
>
> I need to enter 2 days before but it must be a weekday.
> e.g 12 Sep 2005 must show 9 Sep 2005 and also 13 Sep 2005 must show 9
> Sep 2005.
>
> What I have is NOW()-2 , but it shows 10 Sep 2005 which is wrong.
>
Hi

Try
=IF(WEEKDAY(TODAY())=6,TODAY()-1,IF(WEEKDAY(TODAY())=1,TODAY()-2,TODAY()-2))

Regards
Peter

=IF(WEEKDAY(TODAY(),2)<3,TODAY()-1-WEEKDAY(TODAY()),TODAY()-2)

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk


"Heckstein" <[email protected]> wrote
in message news:[email protected]...
>
> Hi!
>
> Could you please help me with date formula.
>
> I need to enter 2 days before but it must be a weekday.
> e.g 12 Sep 2005 must show 9 Sep 2005 and also 13 Sep 2005 must show 9
> Sep 2005.
>
> What I have is NOW()-2 , but it shows 10 Sep 2005 which is wrong.
>
>
> --
> Heckstein
> ------------------------------------------------------------------------
> Heckstein's Profile:
> http://www.excelforum.com/member.php...o&userid=27153
> View this thread: http://www.excelforum.com/showthread...hreadid=466653
>

On Sun, 11 Sep 2005 14:26:18 -0500, Heckstein
<[email protected]> wrote:

>
>Hi!
>
>Could you please help me with date formula.
>
>I need to enter 2 days before but it must be a weekday.
>e.g 12 Sep 2005 must show 9 Sep 2005 and also 13 Sep 2005 must show 9
>Sep 2005.
>
>What I have is NOW()-2 , but it shows 10 Sep 2005 which is wrong.

=WORKDAY(TODAY()-1,-1)

Note that with this function, you can optionally add a list of Holidays.


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

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

--ron