That's OK if you regard 30th September and 1st October as being a month
apart.

If you want to wait for a month to be completed (for example from 15th of
one month to 15th of the next), then use the DATEDIF function as previously
advised.
--
David Biddulph

"omnitechsupport" wrote in
message ...
Use the formula below to calculate the number of months between two dates.

=(YEAR(cell2)-YEAR(cell1))*12+MONTH(cell2)-MONTH(cell1)

For example:
If you want to calculate the number of months between 15/08/1995 and
31/07/2008, do the following.

Enter the first date in cell "A1" and the second date in cell "A2".
Then format both cells using "date format."
Enter the above mentioned formula on cell "A3" as
"=(YEAR(A2)-YEAR(A1))*12+MONTH(A2)-MONTH(A1)" [without double quotation]


This should help..



"VKL Narayanan" wrote:

I have two dates say 15/08/1995 and 31/07/2008, I want to calculate the
number of months between these two dates mentioned. how do I do that?