ExcelBanter - How to automatically update the date any time the Excel is openned

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to automatically update the date any time the Excel is openned (https://www.excelbanter.com/excel-worksheet-functions/56443-how-automatically-update-date-any-time-excel-openned.html)

DORI

How to automatically update the date any time the Excel is openned

I have a worksheet with a certain cell dedicated for today's date. Is it
possible to programm that cell so that any time I open the file, it
automatically reflects the today's date?
Thanks,
Dori

Dave Peterson

How to automatically update the date any time the Excel is openned

You could use:
=today()

If you need date and time, you could use:
=now()
(format it nicely)

DORI wrote:

I have a worksheet with a certain cell dedicated for today's date. Is it
possible to programm that cell so that any time I open the file, it
automatically reflects the today's date?
Thanks,
Dori

--

Dave Peterson

DORI

How to automatically update the date any time the Excel is ope

Thank you very much Dave.
Dori

"Dave Peterson" wrote:

You could use:
=today()

If you need date and time, you could use:
=now()
(format it nicely)

DORI wrote:

I have a worksheet with a certain cell dedicated for today's date. Is it
possible to programm that cell so that any time I open the file, it
automatically reflects the today's date?
Thanks,
Dori

--

Dave Peterson

All times are GMT +1. The time now is 02:17 AM.