LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default How to use Today's date in a cell and make it stay the same date

Hello all

I am working on a purchase order form in Excel 2003. On top of the sheet I
have a cell with the formulla =TODAY() which shows todays date on that cell.
Obviously this is not the correct code for what I need. If I open the file
tomorrow it will show me tomorrows date and thats not what I am after. Is
there a way to get todays date on that cell and make it permanent? For
example, I create a new sheet and automatically I get the date on top and no
matter when I open that sheet again, I get the date that I created that sheet.
 
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
conditional formatting for cell date to equal today's date Sistereinstein Excel Worksheet Functions 2 September 10th 12 07:53 PM
text and today's date in 1 cell rexie3 Excel Discussion (Misc queries) 5 February 8th 07 10:38 PM
Combine text and today's date in a cell Sheila Excel Worksheet Functions 6 August 29th 06 11:15 PM
Fill cell with today's date Sarahbkelly Excel Discussion (Misc queries) 6 January 20th 06 01:16 AM
find cell with today's date James D Excel Discussion (Misc queries) 2 January 16th 06 09:59 PM


All times are GMT +1. The time now is 02:37 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"