G
Guest
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
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