Howdy All,

I have 2 columns in my spreadsheet:

B:B is a column of dates.
C:C is a list of names

Could someone suggest a formula that will count the number of times the name 'SIMON' appears in column C:C but here is the catch: I only want to know how many times that name has appeared over the course of the previous week. IE NOW - 7days

any help really appreciated.