How to determine the number of month between 2 periods?

[Guest]

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

 

[Guest]

If I understand correctly then you want the difference between 2 dates
including the start and end date i.e. 1/1/2007 - 30/9/2007 would return 9. If
my understanding is correct then this will do it.

=(YEAR(B1)-YEAR(C1))*12+MONTH(B1)-MONTH(C1)+1

Note you will have to change the cell format to General after entering this.

Mike

 

[JE McGimpsey]

One place to start is

A1: 23 Feb 2006
B1: 1 Apr 2006
C1: =DATEDIF(A1,B1,"m")

However, you need to be careful when it comes to how "month" is defined.
Is 31 January 2007 to 28 February 2007 one month? or zero? (Datedif
returns 0)

 

[Guest]

Thank you for your suggestion
Eric

If I understand correctly then you want the difference between 2 dates
including the start and end date i.e. 1/1/2007 - 30/9/2007 would return 9. If
my understanding is correct then this will do it.

=(YEAR(B1)-YEAR(C1))*12+MONTH(B1)-MONTH(C1)+1

Note you will have to change the cell format to General after entering this.

Mike

 

[David Biddulph]

That's OK providing that you realise that 1/1/07 to 31/1/07 is one month,
but 31/1/07 to the following day, 1/2/07, is 2 months.

 

[Guest]

Thank everyone for suggestions
I try to ignore the day and count the month only on my approach
Thank everyone
Eric