Excel Formulae - number of months between start and end date

Copper Contributor

Looking for a formulae that will return number of months between two dates but that rounds up or down when calculating outcome and not complete months between the date. So if calculating between a start date of 11 Apr 2020 and 31 Mar 2021 it will return a value of 12 and not 11. Further if calculating the same for between 20 Apr 20 and 31 Mar 21 it will return a value of 11

1 Reply

@nigelkick 

Could you please clarify a bit what is the rule for such rounding. In first case we have 11 months 20 days which goes to 12 months. In second case 11 months 11 days which is considered as 11 months. What is the logic behind?