In the example shown the formula in D6 is. Select the cell in which you want to insert the formula. In this example the start date is in cell D9 and the end date is in E9.
In the Date 1 box enter the.
To calculate months between two dates as a whole number you can use the DATEDIF function. To calculate and display the time between dates in days months and years you can use the a formula based on the DATEDIF function. However the function was only introduced in Excel 2013 so is not available in earlier versions of Excel. In this example the start date is in cell D5 and the end date is in E5.