ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   today's date (https://www.excelbanter.com/excel-worksheet-functions/26724-todays-date.html)

CK

today's date
 
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()

"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?




Chip Pearson

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?





All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com