Recall & Review
beginner
What does the DATEDIF function do in Excel?
DATEDIF calculates the difference between two dates in days, months, or years.
Click to reveal answer
beginner
What is the correct syntax for the DATEDIF function?
DATEDIF(start_date, end_date, unit)<br>Where unit can be "Y", "M", "D", "MD", "YM", or "YD".
Click to reveal answer
beginner
What does the unit "Y" mean in DATEDIF?
It returns the number of complete years between the start_date and end_date.
Click to reveal answer
intermediate
How does the "MD" unit in DATEDIF work?
It returns the difference in days, ignoring months and years. For example, difference in days between the days of the two dates.
Click to reveal answer
intermediate
Why might DATEDIF sometimes give unexpected results?
Because it is an undocumented function in Excel and can behave oddly with invalid dates or if start_date is after end_date.
Click to reveal answer
What does the formula =DATEDIF("2023-01-01", "2024-01-01", "Y") return?
✗ Incorrect
The unit "Y" returns the number of complete years between the two dates, which is 1.
Which DATEDIF unit returns the difference in months ignoring years?
✗ Incorrect
"YM" returns the number of months between dates ignoring years.
If start_date is after end_date, what happens with DATEDIF?
✗ Incorrect
DATEDIF returns a #NUM! error if start_date is after end_date.
What does the unit "D" in DATEDIF calculate?
✗ Incorrect
"D" returns the total number of days between the two dates.
Which of these is NOT a valid unit for DATEDIF?
✗ Incorrect
"WD" is not a valid unit for DATEDIF.
Explain how to use DATEDIF to find the number of complete months between two dates.
Remember the unit for months is "M" and start_date should be before end_date.
You got /3 concepts.
Describe the difference between the DATEDIF units "MD" and "D".
Think about whether months and years are considered in the calculation.
You got /3 concepts.