calculate months

[Mellefranken]

Suppose in cell A1 I enter a date 1-3-2007 (1 March 2007).

In another cell A2 I want to calculate the remaining months in that particular year (2007). So the answer is 9.

I hope someone can help me.

[jasoncw]

In A2:

=12-MONTH(A1)

HTH

Jason