Question: how to subtract two dates in excel and 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.