Calculating months

[pkeegs]

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

 

[davesexcel]

try the datedif function

=DATEDIF(A1,B1,"m")

 

[pkeegs]

Thanks Dave,
DATEDIF gives the months difference, I want the months inclusive. I think I
will be able to use this function though with a bit of manipulation unless
you have another answer.
Incidentally, as a function I cannot bring up "DATEDIF" on my help screens.

 

[davesexcel]

Thanks Dave,
DATEDIF gives the months difference, I want the months inclusive. I
think I
will be able to use this function though with a bit of manipulation
unless
you have another answer.
Incidentally, as a function I cannot bring up "DATEDIF" on my help
screens.

[/QUOTE]
Either can I,
it seems to be one of those secret functions

 

[HeyNow100]

I have Walkenbach's Excel 2003 Bible right in front of me. He mentions
the lack of references to it in the last few versions of the Excel.
Apparently the function has its origins in Lotus123 and is still there
for compatability reasons. No idea why they still don't want to
mention it in the online help.

 

[pkeegs]

My simple answer to have the inclusive number of months is to add 1 at the
end of the formula and it is working well, hence =DATEDIF(A1,B1,"m")+1

Thanks & regards (Interesting about the lack of help on the function)