Creation date cell

Question

In Excel, in a template or file that is reused over and over, I want to automatically set the creation date of the first saving of that version in a visible cell, and maintain it for the life of the document. Creating a second cell to show updates and save dates is not a problem, Need to keep the creation date out front. I would like it to be automatic on the first save.

Any thots

Answer 1

Hello Warren,

When you determine your issue is resolved please mark it Solved and indicate the answer was helpful.

This will help if other users are searching for answers.

I am glad I could be of assistance.

If you do need more information please post back. so either I or another forum user can assit.

CDN-Carl

Answer 2

So if I understand it, this formula goes in the cell I am trying to show the date?

Answer 3

Thank you for getting back to me. Yes, that is correct. if there was a away to save the first "save as" date that wouldn't change without a lot of bally-hoo, I am working with several people with diverse excel experience, and I was trying to simplify their ability to know when they first save the file as a "new" Template.

In the past we created the date in the actual save as File Title, ie: "ABCD Part 211005". With so many people in our company that are creating these files, it has been a struggle to get everyone on the same page and date format, ie: Military - YMD: 211005; MDY: 100521; Old English - DMY: 051021 and then get them to include it is another struggle. They aren't stupid, just super busy and sometimes forget to change the name when saving to begin with.

So simple is better and if you have a solution, I would be more than grateful.

Even if it requires a script that, when they are exiting and saving it, they are prompted to answer a question, ie: Is this a new file? Do you want to save it as a new entity? And them opens the save as dialog. I can see the answer, I just don't know how to get there in excel.

Thanks Carl.

Warren

Answer 4

Hello Warren,

You can place the below code in ThisWorkbook.

It verifies if any data is in your first saved cell. If not it puts today's data and time in. If the cell has data then it skips the step.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

If Sheet1.Range("$B$1") = "" Then

 Sheet1.Range("B$1") = BuiltinDocumentProperties("Last Save Time") 

End If

End Sub

I hope this helps.

CDN-Carl

Answer 5

Hello Warren,

I understand you want to display the file creation date in a cell.

This being the information showed in the Created field below? Except you want to use the first saved date not the date of the creation of the file.

I expect you have a templated file and when a user opens an instance and saves it that is the creation date you are interested in? I am correct in this assumption?

Please reply back.

CDN-Carl