Date Calculation

[schaferdd]

I have 2 dates (in separate cells) and formatted as mm/dd/yyyy.
I can subtract the 2 to determine the variance in number of days, but how would I determine 'number of years' that factors leap years?
Not sure what the formula should be?
Your assistance is much appreciated.

 

[AhoyNC]

Try:

Book1
	A	B	C
1	2/25/2012		Years
2	3/8/2020		8
Sheet3

Cell Formulas
Range	Formula
C2	C2	=DATEDIF(A1,A2,"y")

 

[schaferdd]

Thank you.