Question: how to calculate date difference in excel 2016?
Answer: Use DATEDIF to find the total years. ...  Use DATEDIF again with “ym” to find months. ...  Use a different formula to find days.