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 |
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) |