ExcelBanter - How to determine the number of month between 2 periods?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to determine the number of month between 2 periods? (https://www.excelbanter.com/excel-worksheet-functions/133754-how-determine-number-month-between-2-periods.html)

Eric

How to determine the number of month between 2 periods?

Referring to the post in General Question

Does anyone know how to determine the number of month between 2 periods?
such as
23 Feb, 2006 and 1 Apr, 2006, it returns 2 months difference and not
counting the starting day. And always start to count Feb, 2006 and Apr, 2006.
Does anyone have any suggestion?
Thank you in advance
Eric

Mike

How to determine the number of month between 2 periods?

Why don't you refer to the post in General?

"Eric" wrote:

Referring to the post in General Question

Does anyone know how to determine the number of month between 2 periods?
such as
23 Feb, 2006 and 1 Apr, 2006, it returns 2 months difference and not
counting the starting day. And always start to count Feb, 2006 and Apr, 2006.
Does anyone have any suggestion?
Thank you in advance
Eric

All times are GMT +1. The time now is 10:45 PM.