| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula help for counting,with a column of dates and a column of n | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How do I take a column of dates and add six months? | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
Linear Mode
