"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