Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count if function using dates
I have a spreadsheet the has a column of dates. I want to use count if
statements to tell me how many of the cells have a date that is less than 7 days in the past, how many of the cells have a date 7 to 30 days in the past, how many of the cells have a date 31 to 60 days in the past, how many of the cells have a date 61 to 90 days in the past, and how many of the cells have a date greater than 90 days in the past. Lets say D1:D100 is the range I would like to check. I have 5 different cells that I would like to display the five date ranges mentioned. Please help!!!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
count if function using dates
Hi
Use helper cells holding the date of today less 7, 31, 61, etc. Then, to count, use: =COUNTIF(rangeofdates,"<="&date1)-COUNTIF(rangeofdates,"<"&date2) Here, date1 and date2 both refer to a helper cell you set up. Make sure date2 is the larger of the 2, so marking the upper date of an interval. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Chris O''''Neill" wrote: I have a spreadsheet the has a column of dates. I want to use count if statements to tell me how many of the cells have a date that is less than 7 days in the past, how many of the cells have a date 7 to 30 days in the past, how many of the cells have a date 31 to 60 days in the past, how many of the cells have a date 61 to 90 days in the past, and how many of the cells have a date greater than 90 days in the past. Lets say D1:D100 is the range I would like to check. I have 5 different cells that I would like to display the five date ranges mentioned. Please help!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count of Dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
count dates | New Users to Excel | |||
How do a count dates? | Excel Discussion (Misc queries) | |||
How do a count dates? | Excel Discussion (Misc queries) |