Counting Months

F

Farrel

I'm using this formula to count months: =DATEDIF(a1,TODAY(),"m")+1, but I
cannot count September and October.... any clue
 
M

Morrigan

I tried your formula it worked for me. Are you trying to count
September and October of 2005 which is in the future?
 
F

Farrel

No... I know this formula will count all the months...
But I need to create an exception for September and October.
I don't need to count September and October.

Oh... by the way, thank's for your help
 
R

Ron Rosenfeld

I'm using this formula to count months: =DATEDIF(a1,TODAY(),"m")+1, but I
cannot count September and October.... any clue
Click to expand...

To not count Sep and Oct, try this **array** formula:

=DATEDIF(A1,TODAY(),"m")+1-SUM(
--(MONTH(DATE(YEAR(A1),MONTH(A1)+
ROW(INDIRECT("1:"&DATEDIF(
A1,TODAY(),"m")+1))-1,1))={9,10}))

To enter an array formula, after typing/pasting it in, hold down <ctrl><shift>
while hitting <enter>. Excel will place braces {...} around the formula. The
result should be as accurate as the results of the DATEDIF formula.


--ron
 
Top