Now() -3 days

Ella · Sep 9, 2005

What is the correct statement in writing a formula that where it will
display 3 days before.
ex. I need to display previouse friday's date and i am run the report
on monday.

Anne Troy · Sep 9, 2005

Hi, Ella. You've got it: =now()-3 or =today()-3
Change the cell format to display only the date, if desired.
************
Anne Troy
www.OfficeArticles.com

Ella · Sep 9, 2005

oh duh!!thanks

Anne said:
Hi, Ella. You've got it: =now()-3 or =today()-3
Change the cell format to display only the date, if desired.
************
Anne Troy
www.OfficeArticles.com