From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Use NOW() and TODAY() functions and calculate dates using WEEKDAY() and WORKDAY() functions
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Use NOW() and TODAY() functions and calculate dates using WEEKDAY() and WORKDAY() functions
- [Narrator] In this video we are going to explore four Date functions. The NOW function returns the system date and time. The TODAY function returns just the system date. The WEEKDAY function will take any date that you give it and tell you which day of the week that date fell on, or will fall on. And the WORKDAY function, will take information that you supply, such as what the start date of a project is, how many days you think it will take to complete, and if there are any holidays that are going to fall within that time frame that will affect the final date. Let's take a look at our Date Functions workbook. First, let's use the NOW function. I clicked in F1 and I'll type in equals now, open closed parenthesis. When I hit Tab or Enter, and I expand the width of this cell, you'll see that it returned the date June 13th, 2019 and the system time. Now let's compare that to the TODAY function. Equals today and open…
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
-
-
-
-
-
-
Use AND(), OR(), and NOT() in nested functions6m 9s
-
Use IF() and IFS() in nested functions4m 31s
-
(Locked)
Use SWITCH() in nested functions3m 38s
-
Use SUMIF(), AVERAGEIF(), SUMIFS(), and AVERAGEIFS() functions5m 2s
-
(Locked)
Use COUNT() and COUNTIF()2m 54s
-
Use MAXIFS() and MINIFS() in nested functions3m 27s
-
(Locked)
Look up data using VLOOKUP() and HLOOKUP()5m 52s
-
Use the MATCH() and INDEX() functions5m 47s
-
(Locked)
Use NOW() and TODAY() functions and calculate dates using WEEKDAY() and WORKDAY() functions8m 15s
-
(Locked)
Summarize data from multiple ranges by using the Consolidate feature3m 10s
-
(Locked)
Use What-If Analysis Goal Seek and Scenario Manager5m 57s
-
(Locked)
Calculate financial data with NPER() and PMT() functions3m 30s
-
(Locked)
Troubleshoot formulas9m 24s
-
(Locked)
Challenge: Create advanced formulas27s
-
(Locked)
Solution: Create advanced formulas9m 8s
-
-
-
-