View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tjsmags tjsmags is offline
external usenet poster
 
Posts: 21
Default How input today's date and keep that date

I need to input today's date in my worksheet. But, I want that date to stay
THAT date when I open it up a month from now...I don't want it to change to
today's date.

For example, I'm working on my worksheet today and have a cell that input's
today's date next to the data I have. So, it inputs 12/30/07. When I open
this worksheet a month from now I do NOT want it to change that cell to show
today's date (i.e. 01/30/08)...I want it to keep 12/30/07.

How do I do that?