From the course: Excel 2016: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Using the TODAY and NOW functions for dynamic date and time entry
From the course: Excel 2016: Advanced Formulas and Functions
Using the TODAY and NOW functions for dynamic date and time entry
- Excel has two functions related to date and time that allow us to work with dates and times in a dynamic fashion. In cell A2, I want to depict the current date. At the time of this recording, it's December 9th of 2015. If I simply want to put in today's date as if I were typing it, I'll press Ctrl-Semicolon, a great shortcut. And if I want to put in the current time, I'll press Ctrl-Shift-Semicolon. That puts in the current time. Now, if I want to use the date in a dynamic way, there's the function called TODAY. And as you type it, type =today( that's all you need to type, press enter. And, for the current time, =now( but this will display the current date and time together. Both of these entries are dynamic, meaning, as we go about our business and do other things on the worksheet, we might check back here and they might change. Now, if it were near midnight and I'm working and I'm making some changes here, there, whatever, at some point I might look over here, and it might then…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
Understanding Excel date and time capabilities in formulas9m 52s
-
Using the DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE, and SECOND functions4m 4s
-
Using the TODAY and NOW functions for dynamic date and time entry6m 49s
-
Identifying the day of the week with the WEEKDAY function4m 40s
-
Counting working days with the NETWORKDAYS function5m 26s
-
Determining a completion date with the WORKDAY function4m 10s
-
Tabulating date differences with the DATEDIF function6m 15s
-
Calculating end-of-month and future and past dates with EDATE and EOMONTH4m 58s
-
-
-
-
-
-