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" wrote in message
ps.com...
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.