J
jesseok
Please tell me the correct argument for causing the date to update each time
you use excel. Thank you
you use excel. Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
Put this in a cell:
=TODAY()
It will pick up your system date whenever you use the file.
Hope this helps.
Pete
=TODAY()
It will pick up your system date whenever you use the file.
Hope this helps.
Pete
B
Bob I
you mean NOW() ?
J
jesseok
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
Put this in a cell:
=TODAY()
It will pick up your system date whenever you use the file.
Hope this helps.
Pete
S
ShaneDevenshire
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.
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.
P
Pete_UK
You're welcome - nice to get some feedback now and then!
Pete
Pete
E
ebloch
or to manually enter current date in current cell press <ctrl>+:
S
ShaneDevenshire
Hi,
The shortcut key for Current Date is Ctrl+; (semi-colon)
Ctrl+: (colon) is the shortcut key for current Time.
The shortcut key for Current Date is Ctrl+; (semi-colon)
Ctrl+: (colon) is the shortcut key for current Time.