View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ADSK ADSK is offline
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.