count months between two dates

[hibster]

Hi board

i need a formula that will count months between dates. I have 2 columns side by side which have start date and todays date and i need to know how many months inbetween.

EG

24/01/07 12/09/07 7

i need the answert to be 7 as i want it to calculate all months that are in the range.

Cheers for the help as always.

Hibster

 

[c_m]

Try:
=ROUND((B1-A1)/30.5,0)-N(DAY(B1) < DAY(A1))<day(a1))>
where A1 = 24/01/07 and B1 = 12/09/07</day(a1))>

 

[jbeaucaire]

The DATEDIF function is designed for this:

=DATEDIF(A1,B1,"m")