Months calculation

[savethisid]

Hi,

I have two dates in excel

in A1 i have 201101 which is year and month together
&
in b1 i have 201202 which is year and month together

i need to find out months in between the two dates...

please help

 

[Andrew Poulsom]

Are those just numbers or serial dates formatted as yyyymm?

 

[savethisid]

Hi Andrew,

yes its formatted as yyyymm

 

[savethisid]

Sorry Andrew

just noticed its not yyyymm but just numbers

 

[Akashwani]

Hi,

Are those actual dates or not?

Take a look here on how to calculate the number of months between two dates....

DATEDIF Worksheet Function

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1
2	201101	201202		3	3	Incorrect not dates		1	Correct
3	201101	201202		13	1	Correct actual dates		-3	Incorrect
4
Sheet4

I hope that helps.

Good luck.

Ak

 

[Andrew Poulsom]

How about?

=((LEFT(A2,4)-LEFT(A1,4))*12)+RIGHT(A2,2)-RIGHT(A1,2)

 

[Weazel]

Probably a better way but its late....

=DATEDIF(DATEVALUE(TEXT(A1,"00-00")&"-01"),DATEVALUE(TEXT(B1,"00-00")&"-01"),"m")