Calculate the difference between two dates - Microsoft Support
https://support.microsoft.com/en-us/office/calculate-the-difference-between-two-dates-8235e7c9-b430-44ca-9425-46100a162f38
OverviewDifference in daysDifference in weeksDifference in monthsDifference in yearsCalculate age in accumulated years, months, and daysDownload our examplesOther date and time calculationsRelated Topics 1. Use DATEDIF to find the total years.In this example, the start date is in cell D17, and the end date is in E17. In the formula, the “y” returns the number of full years between the two days. 2. Use DATEDIF again with “ym” to find months.In another cell, use the DATEDIF formula with the “ym” parameter. The “ym” returns the number of remaining months past the last full year.
1. Use DATEDIF to find the total years.In this example, the start date is in cell D17, and the end date is in E17. In the formula, the “y” returns the number of full years between the two days.
2. Use DATEDIF again with “ym” to find months.In another cell, use the DATEDIF formula with the “ym” parameter. The “ym” returns the number of remaining months past the last full year.
DA: 1 PA: 97 MOZ Rank: 70
