That's great! Thanks Lars-Åke

Lars-Åke Aspelin wrote:
On Sun, 25 Jan 2009 17:09:31 +0900, Ricky
wrote:

Hi - I'm after a formula to find the number of completed months between
2 dates. This may at times go through to the next year - for example:

Cell A1 I have "11:00AM 15/06/09"
Cell A2 I have " 3:00PM 25/02/10"
Cell B3 I want " 7 " to be returned.

Cells A1 and A2 are formatted as hh:hh AM/PM dd/mm/yy

Can anyone suggest a formula I can place in cell B3 to return the number
of completed months?

Tks, Ricky


Try this formula in cell B3:

=MAX(ROW(1:1000)*(DATE(YEAR(A1),MONTH(A1)+ROW(1:10 00)+1,1)<=A2))

Note: this is an array formula that should be confirmed with
CTRL+SHIFT+ENTER rather than just ENTER.

The 1000 in two places can be replaced with any number that is bigger
than the biggest expected result.

Hope this helps / Lars-Åke