Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Now() -3 days
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
oh duh!!thanks
Anne Troy wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Return only work days | Excel Discussion (Misc queries) | |||
Vacation Accrual Formula | Excel Worksheet Functions | |||
Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |