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.

	A	B
1	Date1	Month
2	12/1/2017
3	12/26/2017
4	1/20/2018
5	2/14/2018
6	3/11/2018
7	4/5/2018

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[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.

	A	B
1	Date1	Month
2	12/1/2017
3	12/26/2017
4	1/20/2018
5	2/14/2018
6	3/11/2018
7	4/5/2018

<tbody>
</tbody>

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 !