software

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

Dates in A2:A50

=COUNTIF(A2:A50,quot;gt;=quot;amp;DATE(YEAR(TODAY()),MONTH(TODA Y())-6,DAY(TODAY())))

or

=SUMPRODUCT(--(A2:A50gt;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

quot;Kayequot; gt; wrote in message
...
gt;I have a column of dates. I want to count the number of dates that are six
gt; months or less from today. Any help would be appreciated.
gt; kayeI suggest putting the start date and end date [cell formula can be
=today()], and using countif:
www.officearticles.com/excel/...ft_excel.h tm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

quot;Kayequot; gt; wrote in message
...
gt;I have a column of dates. I want to count the number of dates that are six
gt; months or less from today. Any help would be appreciated.
gt; kaye