Now() -3 days

[Ella]

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]

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]

oh duh!!thanks

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