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