![]() |
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 |
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