View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris O''''Neill Chris O''''Neill is offline
external usenet poster
 
Posts: 3
Default 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!!!!!!