ExcelBanter - Revised dates in excel

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Revised dates in excel (https://www.excelbanter.com/new-users-excel/106896-revised-dates-excel.html)

Fifee

Revised dates in excel

How can I add a date that automatically updates every time it is opened excel
(I can do it in Word, but not in excel

Gord Dibben

Revised dates in excel

In a cell enter =TODAY()

This will update each day.

Gord Dibben MS Excel MVP

On Thu, 24 Aug 2006 10:14:02 -0700, Fifee
wrote:

How can I add a date that automatically updates every time it is opened excel
(I can do it in Word, but not in excel

tim m

Revised dates in excel

=TODAY()
in a cell should update each time it is opened.

"Fifee" wrote:

How can I add a date that automatically updates every time it is opened excel
(I can do it in Word, but not in excel

All times are GMT +1. The time now is 04:15 AM.