| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Today minus 1 day
What is the formula for current date, minus one day?
Thank you so much! -- MB |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Today minus 1 day
Try this:
=TODAY()-1 Remember to format the result as a date. Does that help? *********** Regards, Ron XL2002, WinXP "MB" wrote: What is the formula for current date, minus one day? Thank you so much! -- MB |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Today minus 1 day
duh. (!) As soon as I saw your answer, I felt really silly. Thank you SO
much! -- MB "Ron Coderre" wrote: Try this: =TODAY()-1 Remember to format the result as a date. Does that help? *********** Regards, Ron XL2002, WinXP "MB" wrote: What is the formula for current date, minus one day? Thank you so much! -- MB |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Today minus 1 day
=Today()-1
"MB" wrote: What is the formula for current date, minus one day? Thank you so much! -- MB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically filling date of today (without it changing tomorrow) | Excel Discussion (Misc queries) | |||
| Dealing with minus numbers in formulas | Excel Discussion (Misc queries) | |||
| converting minus quantities to plus | New Users to Excel | |||
| strip minus signs from right to left | Excel Discussion (Misc queries) | |||
| minus formel/fortegn | Excel Discussion (Misc queries) | |||
Hybrid Mode
