counting dates in a column that less than 6 months from today
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 |
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 |
counting dates in a column that less than 6 months from today
I suggest putting the start date and end date [cell formula can be
=today()], and using countif: http://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 "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 |
All times are GMT +1. The time now is 09:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com