![]() |
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. |
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. |
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