ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Putting computer date in cell (https://www.excelbanter.com/excel-discussion-misc-queries/51858-putting-computer-date-cell.html)

Fitz

Putting computer date in cell
 
How do I get excel to put the current date (ie.computer date) in a specific
cell so that each time I open the file the current date is in that
particular cell.



Jim May

Putting computer date in cell
 
=today() < for day only
or
=Now() for day and time

"Fitz" wrote in message
.. .
How do I get excel to put the current date (ie.computer date) in a
specific cell so that each time I open the file the current date is in
that particular cell.




Rowan Drummond

Putting computer date in cell
 
=Today()

This is a volatile function so it will be recalculated everytime the
file is opened, closed or any other operation triggers calculation.

Hope this helps
Rowan

Fitz wrote:
How do I get excel to put the current date (ie.computer date) in a specific
cell so that each time I open the file the current date is in that
particular cell.




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

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