Thread: How do I create formula to calc difference in dates?
View Single Post
  #3  
Old December 31st, 2007, 02:37 AM posted to microsoft.public.excel.misc
mike
external usenet poster
  
Posts: 3,942
Default How do I create formula to calc difference in dates?
=MONTH(A1)-MONTH(B1)

That works when the two months are in the same year, but what if they are in
different years? For example January 2008-September 2007 = -8, but should
equal 4. Or December 2008-January 2006 = 11, but should equal 23.