Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
outlok today [ display name ] drpepper Excel Discussion (Misc queries) 1 November 16th 05 03:15 PM
How do I use the TODAY function with the SUMIF function? Lisa B. Excel Worksheet Functions 2 September 30th 05 08:51 PM
Conditional Formatting Cell < Today() sagan Excel Worksheet Functions 3 September 21st 05 03:43 PM
calculating number of months from today JNW Excel Worksheet Functions 5 September 15th 05 10:01 PM
Count the number of dates in a range that are earlier than today. DeborahS Excel Worksheet Functions 1 March 9th 05 01:54 AM


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"