Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
tbw
 
Posts: n/a
Default 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   Report Post  
BekkiM
 
Posts: n/a
Default

=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   Report Post  
Vacation's Over
 
Posts: n/a
Default

=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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
date format in excel not in line with control panel regional setti GrahamR Excel Discussion (Misc queries) 3 August 2nd 05 06:48 PM
today's date in excel David Excel Discussion (Misc queries) 2 June 2nd 05 01:15 PM
Automatic Populate Todays Date in Cell when File is Saved. Nello Excel Discussion (Misc queries) 3 April 21st 05 11:08 PM
Exporting from MYOB to Excel the date cell doesn't display as dat. VickiO Excel Worksheet Functions 2 March 8th 05 01:43 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"