date formula

[jeongs1]

I need to calculate the whole number of months between below dates and current date - with one formula for all.

Current date = 1/15/2018

So in column B, I'd like to see how many months are between Dates in Column A and the Current Date above.
B2 should be 2, B3 should be 2, B4 should be 1, B5 should be 2, B6 should be 3, and B7 should be 4.

[TABLE="width: 226"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: center"]Date1[/TD]
[TD="align: left"]Month[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]12/1/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]12/26/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]1/20/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]2/14/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]3/11/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[dmj120]

Try month()

=month(a2) and copy down

 

[jeongs1]

That won't work since I need the month difference between dates in Column A and the Current Date aka 1/15/2018.

I've tried DATEDIF and wasn't successful with it.

 

[dmj120]

I need to calculate the whole number of months between below dates and current date - with one formula for all.

Current date = 1/15/2018

So in column B, I'd like to see how many months are between Dates in Column A and the Current Date above.
B2 should be 2, B3 should be 2, B4 should be 1, B5 should be 2, B6 should be 3, and B7 should be 4.

[TABLE="width: 226"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: center"]Date1[/TD]
[TD="align: left"]Month[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]12/1/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]12/26/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]1/20/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]2/14/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]3/11/2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

ops, read it wrong.

Used datedif(start date,end date,"M")
W

 

[jeongs1]

I'm getting one month less for years before the Current Date, and for future dates, I'm getting #NUM !