Count occurances in revolving week

[cheneyg]

Hey Folks,

I have a spread sheet that has dates and names of calls made to customers from a call center (names and dates are sorted in descending order). I am trying to find a function that will count the number of call made to individual customers in a revolving week (7 consecutive days beginning Sunday) in order to identify any privacy violation (calling a customer more than 3 times in a revolving week is a violation).

Can anyone help me out??

[FlameRetired]

Since there is no uploaded example I made one up myself. Please let us know if this does what you want.

[cheneyg]

Thanks so much Flame, works great!

[FlameRetired]

You're welcome and thanks for the feedback.