Thread: Today()
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas
 
Posts: n/a
Default 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