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

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