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.
The first way to do this is to enter a time or date stamp. You can do this with 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, then use the shortcut for time.
Let me add a formula in column D to mirror 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 components. However, cell D9 has both.
I refer to these as date and time stamps because the values won't change. They are 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.
There are also 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 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 change each time I make a change to the worksheet. So, only use the TODAY and 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.
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 using any standard date format. If you need current...
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...