Thread: counting the number or months between two dates.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default counting the number or months between two dates.
On Thu, 6 Nov 2008 13:30:06 -0800, Lisa wrote:

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

Try:

=DATEDIF(A1,A2,"m")
--ron
Reply With QuoteReply With Quote