In this example the start date is in cell D17 and the end date is in E17. Summary To average by month you can use a formula based on the AVERAGEIFS function with help from the EOMONTH function. Below is the formula that will give you the number of months between the two dates.
Summary To average by month you can use a formula based on the AVERAGEIFS function with help from the EOMONTH function.
Here this tutorial introduces a formula that displays the difference between two dates as A years B months C days such as 3 years 2 months 1 days. In this example well look at how to make a RATE formula in its simplest form to calculate interest rate in Excel. For the correct work of Excel MONTH formulas a date should be entered by using the DATE year month day function. Using the CHOOSE and MONTH functions you can also return the month name of a date instead.