The TODAY function will display the current date, and the NOW function will display the current date and time. This is useful when you want to add information about the last time a worksheet was updated, for example.Įxcel also contains two functions that will display a current date and time. They're fixed to the time when you used the shortcut. I refer to these as date and time stamps because the values won't change. Note that the date has no time component, and the current time has no date component. Now let me add a formula in column D to pick up the values in column C, so you can see the actual values. 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. You can do this using keyboard shortcuts.Ĭontrol semicolon enters the current date.Ĭontrol-Shift semicolon enters the current time. You may often want to enter a current date and time into a worksheet.Ī simple way to do this is to enter a time or date stamp. In this video we look at several ways to handle current dates and times.
0 Comments
Leave a Reply. |