Month difference between 2 dates

[jaycee]

I need to find the number of months between 2 dates, I have tried "DATEDIF" but this does not give what I require, below is what is needed

<tbody>
[TD="width: 39%"] A1
[/TD]
[TD="width: 36%"] B1
[/TD]
[TD="width: 25%"] Months
[/TD]

[TD="width: 39%"] 01/01/2017
[/TD]
[TD="width: 36%"] 29/01/2017
[/TD]
[TD="width: 25%"] 1
[/TD]

[TD="width: 39%"] 01/01/2017
[/TD]
[TD="width: 36%"] 01/02/2017
[/TD]
[TD="width: 25%"] 2
[/TD]

[TD="width: 39%"] 01/01/2017
[/TD]
[TD="width: 36%"] 28/02/2017
[/TD]
[TD="width: 25%"] 2
[/TD]

[TD="width: 39%"] 01/01/2017
[/TD]
[TD="width: 36%"] 01/03/2017
[/TD]
[TD="width: 25%"] 3
[/TD]

</tbody>

 

[MikesyM]

Hi jaycee,

How about using this formula:

=MONTH(B1)-MONTH(A1)

This is returning a value 1 less than what you expect, so you might wanna add "+1" to the end.

Hope it helps you.

 

[jaycee]

Many thanks, hopefully this should do the trick

 

[jorismoerings]

Take a look at this:

Book1
	A	B	C	D
1	A1	B1	Months
2	1-1-2017	29-1-2017	1	1,00
3	1-1-2017	1-2-2017	2	2,00
4	1-1-2017	28-2-2017	2	2,00
5	1-1-2017	1-3-2017	3	3,00
Sheet1

Cell Formulas
Range	Formula
D2	=ROUNDUP(YEARFRAC(EOMONTH(A2,-1)+1,EOMONTH(B2,0),3)*12,0)

 

[jaycee]

Many thanks works a treat

 

[barry houdini]

So looking at your table it seems like you are counting any part of a month as a month, so 1/1/2016 to 1/1/2017 should count as 13, right?

Is the start date always 1st of the month, if so try

=DATEDIF(A2,B2,"m")+1

otherwise for any start date

=DATEDIF(A2-DAY(A2)+1,B2,"m")+1