today's date

[CK]

Good Afternoon,

Is there a function which will update the date in a cell to today's date so
it is always up to date?

 

[N Harkawat]

=TODAY()

 

[Chip Pearson]

Use the TODAY function. E.g.,

=TODAY()


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com