|
Today minus 1 day
What is the formula for current date, minus one day?
Thank you so much! -- MB |
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 |
Today minus 1 day
=Today()-1
"MB" wrote: What is the formula for current date, minus one day? Thank you so much! -- MB |
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 |
| All times are GMT +1. The time now is 05:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com