View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Lisa[_3_] Lisa[_3_] is offline
external usenet poster
 
Posts: 11
Default counting the number or months between two dates.

Ok Maybe I did something wrong.

I used =DATEDIF(A1,A2,"ym")
with A1 as 4/30/2007
and A2 as 11/30/2008
result was 7

????????
--
Lisa M.


"John C" wrote:

=DATEDIF(A1,A2,"ym")
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Lisa" wrote:

How do I count the number of months between two dates.
--
Lisa M.