The following examples can help you check if you got the formula right – Example 1.Ĭalculating complete years between two dates (DATEDIF function) How to calculate years between two dates in Excel: If you follow the examples you will see where we calculate the number of years, months,days, hours, minute, seconds, then you can easily derive a formula to calculate years in Excel, as shown below. ( The full image is at the end of this post). The graphic below comes from that page on their website.
The Microsoft Website has a really good post on how to use Microsoft Excel to calculate the difference between two dates.
Excel Hint: How to Use Microsoft Excel 2019 To Calculate the Difference Between Two Dates: Datedif Function
