Thread: Month Counter
View Single Post
  #1   Report Post  
ExcelMonkey
 
Posts: n/a
Default Month Counter

Does anyone know how to count months between two dates. I want to be able to
go beyond 12 months. 01/01/2005 - 01/01/2004 = 13 months.

Month(Date2)- Month(Date1) = will only give me answers from 1 to 12


I was originally using the formula :
INT(Date2-Date1/28). But this does not hold longer term.

This formula works but is ugly:
Month(Date2)-Month(Date1)*12(Year(Date2)-Year(Date1))

Any thoughts on a simpler formula would be appreciated