Question: how to subtract 2 dates in excel to get years?
Answer: Use DATEDIF to find the total years. ...  Use DATEDIF again with “ym” to find months. ...  Use a different formula to find days.