Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi
=DATEDIF(Date1, Date2, "M") (but there may be minor problems with some date combinations) -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "ExcelMonkey" wrote in message ... 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 |
#3
|
|||
|
|||
Try this formula:
=12*(YEAR(A2)-YEAR(A1))+(MONTH(A2)-MONTH(A1)) Pip pip Zorba Eisenhower ExcelMonkey wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions | |||
Add one month to the previuos month | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions | |||
Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
How to extract month number from month name | Excel Discussion (Misc queries) |