Timestamp that won't change

Msgjazz

New Member
Joined
Oct 21, 2003
Messages
45
:banghead: I'm trying to do a Timestamp that won't change every time you reopen the workbook :banghead: . In this linked workbook I have "Meeting Date" in column B. Column E is where I want the Timestamp. So, I can get the timestamp to display the date (I added the hh:mm:ss to test), every time I open the workbook, they all change to the current time. I would like that once a timestamp is entered and the file saved and closed, then when it is reopened, the previous timestamps don't change. So entries made on 9/22/18, regardless of when the meeting is, stay as 9/22/18 when the workbook is again opened to add more meeting.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
There are several different ways to create static timestamps that don't change.
Here is a link that shows different ways of accomplishing that: https://excelchamps.com/blog/timestamp/

You can also have ones that are done automatically upon some data being entered. A simple search should return those (there are literally hundreds, if not thousands, of posts on it in this forum).
 
Upvote 0
Solution

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top