In Excel, Get todays date in a cell
In Excel, how do i get the spreadsheet to automatically update a cell entry
to today's date? (i.e., if i open the spreadsheet on 10/5/05, a cell is programmed to show 10/5/05; if i open it on 10/6/05, the cell shows 10/6/05, etc.). |
=TODAY()
"tbw" wrote: In Excel, how do i get the spreadsheet to automatically update a cell entry to today's date? (i.e., if i open the spreadsheet on 10/5/05, a cell is programmed to show 10/5/05; if i open it on 10/6/05, the cell shows 10/6/05, etc.). |
=Today() Or use =Now() for date and time and format for date
THESE will both show current pc clock settings and updaste with every calculation cycle "tbw" wrote: In Excel, how do i get the spreadsheet to automatically update a cell entry to today's date? (i.e., if i open the spreadsheet on 10/5/05, a cell is programmed to show 10/5/05; if i open it on 10/6/05, the cell shows 10/6/05, etc.). |
All times are GMT +1. The time now is 03:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com