View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Keep todays date, tomorrow

perhaps Copy, Paste Special, Value.

KJ wrote:

On a quoting file I use, I use today's date as =today()
Just one less field I have to enter. Is there a formula I'm missing that
would save the date I created or saved the file?
ei: I open my generic/blank file today on 1/8, save it as a quote number. I
want the quote to say 1/8 'til the end of time. Is there a formula that will
pull the saved date instead of "today()"?
Thanks