Saving date created with =Today()?

  • Thread starter Thread starter BrianG
  • Start date Start date
B

BrianG

I have a sheet where I use =Today() to fill in the date field when the
sheet is created. When the sheet is saved then reopened at some
future time the date field gets changed to the current date. How do I
automatically fill in the date cell when the sheet is first created
and maintain that same date when the sheet is opened for editing at a
future time?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to get the number of days an item was opened from the today's date. 14
Excel Message box with days of month & date. 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
Conditional Validation In Excel 1
VBA Go to Today's Date 4
Selecting todays date 3
Copy Template with Updated Values Each Time 0

Back
Top