Use the TODAY function. E.g.,

=TODAY()


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


"CK" wrote in message
...
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?