Subtracting Dates and showing the answer in months

[mitch1976]

I am trying to subtract 2 dates and show the answer in months even when the dates span more than a year. I have used a datedif formula but can't get it to show the result in months only.

Appreciate any ideas anyone can provide.

[Pepe Le Mokko]

Try =DATEDIF(A2,B2,"m")

[mitch1976]

Wow - That simple!! Thanks I was caught in a web of convaluted formulas. Works like a dream.

[Pepe Le Mokko]

As DATEDIF is not documented anymore by MS you will find info here

[mitch1976]

Excellent - Now in my bookmarks. Thanks again.