counting dates in a column that less than 6 months from today
Dates in A2:A50
=COUNTIF(A2:A50,"="&DATE(YEAR(TODAY()),MONTH(TODA Y())-6,DAY(TODAY())))
or
=SUMPRODUCT(--(A2:A50DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY()))))
the latter is more handy if you need more than one condition
--
Regards,
Peo Sjoblom
Portland, Oregon
"Kaye" wrote in message
...
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
|