Peranently keep dates after open sheet again

  • Thread starter Thread starter pjuskas
  • Start date Start date
P

pjuskas

This I what my goal is;
I have 6 cells where I want to put the todays date in. However eac
cell must contain the date it was edited, even if i open this shee
later on(not update to current data).
When I save my sheet the dates must be permanently stored. So that nex
time I open the sheet, the dates are not overwritten.

I hope someon
 
Hi pjuskas!

If it's you rather than another user, then the best approach is:

Ctrl + ;
Inserts current system date and will not up date when date changes.

Ctrl + Shift + :
Does the same with time

And

Ctrl + ; Space Ctrl + Shift + :
Gives date and time in the cell.

All can be formatted to taste.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top