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