If you want to find the difference between two dates in Excel you can use a normal subtraction formula. Ex. =A1-A2.

This returns the difference in days but autoconverts it into a date. The converted date is incorrectly formatted so to get the number of days between the two dates change the cell format to general (type Ctrl+Shift+~).

If you want to get the number of years between the two dates divide by 365.25 and round up by 1 decimal place. Ex. =ROUND((A1-A2)/365.25,1).

Source: Excel Timesaving Techniques for dummies - Greg Harvey

This article is part of the Tip of the day project