Date Difference Generator
Calculate the gap between two dates in years, months, or days using Excel's DATEDIF function.
DATEDIF
Calculate the difference between two dates in days, months, or years.
The earlier date cell or value.
The later date cell or value.
"Y" for full years, "M" for months, "D" for days.
=DATEDIF(A2, B2, "Y")Checks Before You Paste
- •The start date must be on or before the end date.
- •Use "Y" for whole years, "M" for whole months, "D" for days.
- •For plain day counts you can also just subtract: =B2-A2.