Count Months between two dates, BUT,....

[mark692]

i have two dates and i want to get the month between it but the problem is my first date is in different cell the year is in B2 and the month is in B3 and the 2nd date is in one cell in F2,

like this

	A	B	C	D	E	F	G
2nd Date
Year
Month	January

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]1st Date[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]08/03/2018[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet2​

 

[Rick Rothstein]

Maybe this formula...

=N(MONTH(F2)-MONTH(B3&B2))

 

[mark692]

Maybe this formula...

=N(MONTH(F2)-MONTH(B3&B2))

thanks for your answer sir, this formula works until i change the year date on F2 to 2019

 

[Rick Rothstein]

thanks for your answer sir, this formula works until i change the year date on F2 to 2019

Okay, give this a try then...

=DATEDIF(DATE(B2,1,MONTH(B3&B2)),F2,"m")

 

[mark692]

Thanks you sir! this works