Completed Months between Dates
You are correct David. Seven is correct only if the OP wants the count of
FULL completed months:
July 2009
August 2009
September 2009
October 2009
November 2009
December 2009
January 2010
--
Gary''s Student - gsnu200828
"David Biddulph" wrote:
=DATEDIF(A1,A2,"m") would give the number of completed months, which would
be 8, not 7.
--
David Biddulph
"Ricky" wrote in message
...
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
|