calculate number of months

[xeven_]

If I have two date written as 5/30/1978 12/31/2012 in D1 andE1 is there a formula that will calculate the months from the starting datetill the end date that I can place in F1 ?<o></o>

 

[PaddyD]

datedif(start,end,"M")

 

[cyrilbrd]

Regarding DATEDIF, (since the OP did not specify which version of Excel he/she is using) here is an interesting discussion. link.

 

[Amanda Wilso]

The start date is in cell D1, and the end date is in E1:[FONT=Segoe UI, Segoe UI Web, Segoe UI Symbol, Helvetica Neue, BBAlpha Sans, S60 Sans, Arial, sans-serif]
=[/FONT]DATEDIF[FONT=Segoe UI, Segoe UI Web, Segoe UI Symbol, Helvetica Neue, BBAlpha Sans, S60 Sans, Arial, sans-serif](D1,E1,"m")[/FONT]

 

[xeven_]

Awesome that works perfecly

Thank you