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

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Heckstein" wrote
in message ...

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