count if function using dates

Giganews Newsgroups
Subject: count if function using dates
Posted by:  Chris O''''Neill
Date: Thu, 2 Aug 2007

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

Replies