0
0
Excelspreadsheet~10 mins

DATEDIF for date differences in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows two dates: a start date in A2 and an end date in B2. We want to find the difference in days between these two dates using the DATEDIF formula.

CellValue
A1Start Date
B1End Date
C1Difference (Days)
A22024-01-01
B22024-03-15
C2
Formula Trace
=DATEDIF(A2, B2, "d")
Step 1: DATEDIF("2024-01-01", "2024-03-15", "d")
Cell Reference Map
    A          B          C
1 |Start Date|End Date  |Difference|
2 |2024-01-01|2024-03-15|          |

Arrows: A2 and B2 feed into the formula in C2.
The formula in cell C2 uses the dates from cells A2 (start date) and B2 (end date) to calculate the difference in days.
Result
    A          B          C
1 |Start Date|End Date  |Difference|
2 |2024-01-01|2024-03-15|    74    |
The result 74 in cell C2 shows the total number of days between January 1, 2024 and March 15, 2024.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the "d" argument in the formula =DATEDIF(A2, B2, "d") mean?
ACalculate difference in days
BCalculate difference in months
CCalculate difference in years
DCalculate difference in weeks
Key Result
DATEDIF(start_date, end_date, "d") calculates the number of days between two dates.