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
1	1st Date					2nd Date
2	Year	2018				08/03/2018
3	Month	January
4
5

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</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