Date

  • Thread starter Thread starter jesseok
  • Start date Start date
J

jesseok

Please tell me the correct argument for causing the date to update each time
you use excel. Thank you
 
Put this in a cell:

=TODAY()

It will pick up your system date whenever you use the file.

Hope this helps.

Pete
 
THANK YOU, the _today() did it Thanks again
Put this in a cell:

=TODAY()

It will pick up your system date whenever you use the file.

Hope this helps.

Pete
 
Hi,

You can use either NOW() or TODAY(). The difference is that NOW gets both
the computer's date and time. TODAY gets only the date. Of course you can
format NOW to show just the date.

Both of these functions are volitle - they recalculate everytime the
spreadsheet recalculates.
 
Hi,

The shortcut key for Current Date is Ctrl+; (semi-colon)
Ctrl+: (colon) is the shortcut key for current Time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enter start and end date/time in excel based on some specific value. 7
Formula to fill cells based on Date of Arrival and Date of Departure 1
Import 4 Different Excel Files from One Folder 0
Excel TRYING TO CREATE A FORMULA in excel PLEASE HELP!!! 1
Date recalculates 1
Date Time Stamp formatting 5
Access Problem with Update Command in Access 3
Default date format 4

Back
Top