Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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.). |
#2
|
|||
|
|||
=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.). |
#3
|
|||
|
|||
=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.). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
today's date in excel | Excel Discussion (Misc queries) | |||
Automatic Populate Todays Date in Cell when File is Saved. | Excel Discussion (Misc queries) | |||
Exporting from MYOB to Excel the date cell doesn't display as dat. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |