I want to calculate calendarmonths between two dates eg finish date (A2)31
Mar 2006, start date (A1)1 Oct 2005. The answer wanted is 6 months. I am
currently using =ROUNDUP((A2-A1)/30,0). However not every month is 30 days,
and in this example the formula answer is 7. 2 Oct 2005 would give the right
answer. Similarly, 31 Jan 2006 would return 2, whereas I want it to return 3
(ie three calendar months within the date period). How can I enter the
formula which will recognise what I am trying to do.

Regards