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
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,">="&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
"Kaye" <[email protected]> wrote in message
news:[email protected]...
>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
I suggest putting the start date and end date [cell formula can be
=today()], and using countif:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com
"Kaye" <[email protected]> wrote in message
news:[email protected]...
>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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks