count if function using dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!!!
 
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.
 
Back
Top