From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Use TODAY, NOW, YEARFRAC, and DATEDIF

Use TODAY, NOW, YEARFRAC, and DATEDIF - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Use TODAY, NOW, YEARFRAC, and DATEDIF

- [Instructor] Excel has about 25 different date 2 and time functions, and if you're dealing with data 3 that changes, and you have to have that data up to date, 4 you want to be familiar with the TODAY function 5 and the NOW function. 6 First of all, anytime you want to put in 7 the current dates simply as a static entry, 8 I'm about to do this in cell A2, 9 use the keystroke shortcut Control + semicolon. 10 That will not change unless you change the entry. 11 If you want to put in today's date 12 so that it's always up to date, 13 in other words, it's viewing your system clock, 14 and it will change as you work with the data 15 as you open and close the file, 16 use the function called TODAY, equal TODAY. 17 Like all functions, it's followed by parentheses, 18 but if you're simply typing it as a single entry, 19 put in just the left paren and enter. 20 And for the moment these are identical. 21 But if I close this file and…

Contents