| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning Yesterday
Hello
I want my spreadsheet to return YESTERDAY's date, not TODAY's. I believe it's not possible to embed TODAY() in a formula, so can anyone tell me how to return YESTERDAY'S date into a cell? Thank you. Keith |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning Yesterday
=TODAY()-1
"bollard" wrote: Hello I want my spreadsheet to return YESTERDAY's date, not TODAY's. I believe it's not possible to embed TODAY() in a formula, so can anyone tell me how to return YESTERDAY'S date into a cell? Thank you. Keith |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning Yesterday
How about =TODAY()-1
On May 12, 11:05 am, bollard wrote: Hello I want my spreadsheet to return YESTERDAY's date, not TODAY's. I believe it's not possible to embed TODAY() in a formula, so can anyone tell me how to return YESTERDAY'S date into a cell? Thank you. Keith |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning Yesterday
This should work: =TODAY()-1
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "bollard" wrote: Hello I want my spreadsheet to return YESTERDAY's date, not TODAY's. I believe it's not possible to embed TODAY() in a formula, so can anyone tell me how to return YESTERDAY'S date into a cell? Thank you. Keith |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning Yesterday
It is possible to embed the TODAY() function in a formula:
=TODAY()-1 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "bollard" wrote in message ... Hello I want my spreadsheet to return YESTERDAY's date, not TODAY's. I believe it's not possible to embed TODAY() in a formula, so can anyone tell me how to return YESTERDAY'S date into a cell? Thank you. Keith |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Returning Yesterday
Thanks.
I didn't think that formula worked. I thought I'd tried it, but I'll give it another go. "Teethless mama" wrote: =TODAY()-1 "bollard" wrote: Hello I want my spreadsheet to return YESTERDAY's date, not TODAY's. I believe it's not possible to embed TODAY() in a formula, so can anyone tell me how to return YESTERDAY'S date into a cell? Thank you. Keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please can someone look at question i posted yesterday | Excel Worksheet Functions | |||
| I really need help. Need a formula. Need it yesterday. | New Users to Excel | |||
| continuation from yesterday | Excel Discussion (Misc queries) | |||
| Need absolute time from yesterday | Excel Worksheet Functions | |||
| Message for Frank follow on Q from yesterday | Excel Discussion (Misc queries) | |||
Linear Mode
