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

T

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
 
M

Max

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

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
 
T

Tim Cameron

Hi Max,
Thanks. Works perfectly.
--
Tim


Max said:
One way which might suffice
Source dates in A1 down (assumed real dates)
In B1, copied down: =13-MONTH(A1)
Click to expand...
 
Top