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.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
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>