Calculate exact number of months

I need to establish a formula which can calculate exact number of months between two dates. The end date is fixed as Sept. 1st,2007, and the exact number of months should change according the change of the starting date.

Example, Cell A1= start date = 06/27/2007
B1= end date= 09/01/2007

I tried the following:
C1= # of months= Datedif (A1,B1,"d")/30 =2.20

But I guess its not accurate. Who can help? Thanks!

Hello potato

What do you want the answer to be for your example?

Originally Posted by Potato2007

I need to establish a formula which can calculate exact number of months between two dates. The end date is fixed as Sept. 1st,2007, and the exact number of months should change according the change of the starting date.

Example, Cell A1= start date = 06/27/2007
B1= end date= 09/01/2007

I tried the following:
C1= # of months= Datedif (A1,B1,"d")/30 =2.20

But I guess its not accurate. Who can help? Thanks!

=DATEDIF(A1,B1,"ym")