I've been trawling the messages for a couple of hours now and am getting more
and more confused (it's my age)

I have column A with various dates
Column B has the status "open" or Closed"
I need to count how many new rows were added for each 7 day week. So all the
occurrances of anything between two dates which I have done using
=COUNTIF(range,""&A2)-COUNTIF(range,""&A3) Thanks guys!

but then I need to count the number in each 7 day week that are still open
and then I need to report which date has the oldest "open" item.

Please help

Stu