counting dates in a column that less than 6 months from today

K

Kaye

I have a column of dates. I want to count the number of dates that are six
months or less from today. Any help would be appreciated.
kaye
 
P

Peo Sjoblom

Dates in A2:A50

=COUNTIF(A2:A50,">="&DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))

or

=SUMPRODUCT(--(A2:A50>DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY()))))

the latter is more handy if you need more than one condition


--
Regards,

Peo Sjoblom

Portland, Oregon
 
Top