how to create permanent and flexible dates?

**lori2020** · 02-22-2020, 01:26 PM

I am running OFFICE 2016 on my Mac.

I want to create a template which will have a field for created date: which is stay permanently on the document
and an edited date field which will auto change each time I open document.

I was able to do this in Word but can't figure out how to do in excel.

can anyone help??

I tried to post this question to this forum previous but was notified that my title was not informative enough. so I posted again.

**Richard Buttrey** · 02-22-2020, 01:31 PM

Hi

Just enter a date in a cell and it will remain permanent
Enter the formula =TODAY() in a cell and it will change each day you open the workbook.

**AliGW** · 02-22-2020, 01:34 PM

Administrative Note:

You were NOT asked to open a new thread. I updated the thread title for you AND responded to your query in the original thread.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...-document.html