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!
Bookmarks