| 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 | |||
Linear Mode
