Determine the months remaining from date to the end of the year

[Tim Cameron]

How do I best determine the remaining months from a sepcified date (1
November 2009) the end of that year (2009)? The answer should be 2 months.

Regards
Tim

 

[Max]

One way which might suffice
Source dates in A1 down (assumed real dates)
In B1, copied down: =13-MONTH(A1)

 

[carlo]

if your date is in A1 you could put following formula in A2:
=13-Month(A1)

that would return 2 for every day in november.
Don't forget to format the cell to number, excel will probably change
it to a date, because you are calculating with one.

hth

Carlo

 

[Tim Cameron]

Hi Max,
Thanks. Works perfectly.
--
Tim

One way which might suffice
Source dates in A1 down (assumed real dates)
In B1, copied down: =13-MONTH(A1)

 

[Max]

welcome, Tim