Counting Months
 

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

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


"Morrigan" wrote:


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


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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=399257

On Thu, 25 Aug 2005 12:40:04 -0700, Farrel
wrote:

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

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