Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Litzyam
 
Posts: n/a
Default how can i set up an automatic "date update" in excel?

In other words, i would like excel to update this cell with the current date
every time when i open the document. Can i do that?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: how can i set up an automatic "date update" in excel?

Automatic Date Update in Excel

1. Select the cell where you want the date to appear.
  1. Go to the "Formulas" tab in the ribbon at the top of the Excel window.
  2. Click on the "Insert Function" button and search for the
    Formula:
    =TODAY() 
    function.
  3. Select the
    Formula:
    =TODAY() 
    function and click "OK".
  4. The
    Formula:
    =TODAY() 
    function will now appear in the formula bar at the top of the Excel window.
  5. Press the "Enter" key to insert the current date into the selected cell.
2. Save the Excel document.
3. Close the Excel document.
4. Reopen the Excel document.
5. The date in the selected cell should now be updated to the current date.

That's it! Now every time you open the Excel document, the date in the selected cell will automatically update to the current date.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

one way:

=TODAY()

In article ,
"Litzyam" wrote:

In other words, i would like excel to update this cell with the current date
every time when i open the document. Can i do that?

  #4   Report Post  
Ray A
 
Posts: n/a
Default

One way
=today()
HTH

"Litzyam" wrote:

In other words, i would like excel to update this cell with the current date
every time when i open the document. Can i do that?

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
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
Turn off automatic date formatting? Nick Turner Excel Discussion (Misc queries) 3 July 13th 06 08:13 AM
Update cell based on date range deversole Excel Discussion (Misc queries) 3 July 6th 05 01:58 PM
Automatic Date Update khaji00 Excel Discussion (Misc queries) 2 June 22nd 05 11:48 PM
Automatically enter date and time but only update once. PM New Users to Excel 3 January 21st 05 07:47 AM


All times are GMT +1. The time now is 05:23 PM.

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

About Us

"It's about Microsoft Excel"