Calculate the difference between two dates - Microsoft Support
Calculate the difference between two dates. Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016