In this video we look at several ways to handle current dates and times. You may often want to enter a current date and time into a worksheet.
A simple way to do this is to enter a time or date stamp. You can do this using keyboard shortcuts.
Control semicolon enters the current date.
Control-Shift semicolon enters the current time.
If you want to add both the current date and time use the date shortcut, add a space, and then use the shortcut for time.
Now let me add a formula in column D to pick up the values in column C, so you can see the actual values.
Note that the date has no time component, and the current time has no date component. However, cell D9 has both.
I refer to these as date and time stamps because the values won't change. They're fixed to the time when you used the shortcut. This is useful when you want to add information about the last time a worksheet was updated, for example.
Excel also contains two functions that will display a current date and time.
The TODAY function will display the current date, and the NOW function will display the current date and time. Unlike the date and time stamps above, these functions will continue to update each time the worksheet is opened or changed.
To illustrate, you can see the time value update each time I make a change to the worksheet. So, only use the TODAY or NOW functions if you really want the values to change.
In the end, all of these approaches return valid dates and times, so you can work with them normally using other date functions.
The Excel TODAY function returns the current date, updated continuously when a worksheet is changed or opened. The TODAY function takes no arguments. You can format the value returned by TODAY with a date number...
The Excel NOW function returns the current date and time, updated continuously when a worksheet is changed or opened. The NOW function takes no arguments. You can format the value returned by NOW as a date, or as a date with time by applying a...