DATEDIF for date differences in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to calculate the number of days between two dates in cells A1 and B1.

Excel

=DATEDIF(A1, B1, [1])

Drag options to blanks, or click blank then click option'

A"D"

B"Y"

C"M"

D"MD"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "Y" which counts years instead of days.

Using "M" which counts months instead of days.

The unit "D" tells DATEDIF to calculate the total number of days between the two dates.

2fill in blank

medium

Complete the formula to calculate the number of complete months between two dates in cells A2 and B2.

Excel

=DATEDIF(A2, B2, [1])

Drag options to blanks, or click blank then click option'

A"MD"

B"M"

C"Y"

D"YM"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "MD" which returns leftover days ignoring months and years.

Using "YM" which returns leftover months ignoring years.

The unit "M" returns the number of complete months between the two dates.

3fill in blank

hard

Fix the formula to calculate the leftover days ignoring months and years between dates in A3 and B3.

Excel

=DATEDIF(A3, B3, [1])

Drag options to blanks, or click blank then click option'

A"Y"

B"D"

C"MD"

D"YM"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "D" which counts total days, not leftover days.

Using "YM" which counts leftover months, not days.

The unit "MD" returns the number of days ignoring months and years, showing leftover days.

4fill in blank

hard

Fill both blanks to calculate the difference in years and leftover months between dates in A4 and B4.

Excel

=DATEDIF(A4, B4, [1]) & " years and " & DATEDIF(A4, B4, [2]) & " months"

Drag options to blanks, or click blank then click option'

A"Y"

B"D"

C"YM"

D"MD"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "MD" for months which actually returns leftover days.

Using "D" which returns total days, not years or months.

"Y" calculates full years, and "YM" calculates leftover months ignoring years.

5fill in blank

hard

Fill all three blanks to calculate the difference as years, months, and leftover days between dates in A5 and B5.

Excel

=DATEDIF(A5, B5, [1]) & " years, " & DATEDIF(A5, B5, [2]) & " months, and " & DATEDIF(A5, B5, [3]) & " days"

Drag options to blanks, or click blank then click option'

A"Y"

B"YM"

C"MD"

D"D"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "D" for leftover days which counts total days instead.

Mixing up "M" and "YM" for months.

"Y" counts full years, "YM" counts full months ignoring years, and "MD" counts leftover days ignoring months and years.