ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Today() (https://www.excelbanter.com/excel-worksheet-functions/71851-today.html)

Str8

Today()
 
I have a report that I use today() in part of the formula. Problem is if some
looks at yesterdays report is isn't correct becuse now it using today's date
and not yesterday's when I actually ran the report.
Is there a simular formula or something that works like today() but would
use the day it was created instead of always using the current day.

Hope this makes sense.

Thanks

Bob Umlas

Today()
 
instead of entering =today(), press ctrl/; which will put today's date in as
a constant.

"Str8" wrote in message
...
I have a report that I use today() in part of the formula. Problem is if

some
looks at yesterdays report is isn't correct becuse now it using today's

date
and not yesterday's when I actually ran the report.
Is there a simular formula or something that works like today() but would
use the day it was created instead of always using the current day.

Hope this makes sense.

Thanks





All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com