ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel automatically updates inserted date (https://www.excelbanter.com/excel-worksheet-functions/172399-excel-automatically-updates-inserted-date.html)

Jo

Excel automatically updates inserted date
 
Is there a function that causes the current date to appear in a cell whenever
the worksheet is opened?

David Biddulph[_2_]

Excel automatically updates inserted date
 
=today()
--
David Biddulph

"Jo" wrote in message
...
Is there a function that causes the current date to appear in a cell
whenever
the worksheet is opened?




ryguy7272

Excel automatically updates inserted date
 
Try this:
=today()


Regards,
Ryan--

--
RyGuy


"Jo" wrote:

Is there a function that causes the current date to appear in a cell whenever
the worksheet is opened?


Jo

Excel automatically updates inserted date
 
Thanks David. You're much more helpful than the PaperClip!

"David Biddulph" wrote:

=today()
--
David Biddulph

"Jo" wrote in message
...
Is there a function that causes the current date to appear in a cell
whenever
the worksheet is opened?






All times are GMT +1. The time now is 08:45 PM.

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