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!!!!!! |
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) |