Hi,

I'm tring to get a count of how many days a particular agent worked in a particular (but changing) date range.

I have an excel document (Sheet 1) that contains circa 40 agents (Sheet 1, AP:AP) and the documents they worked each day (Sheet 1, C:C) since the start of the year. I have a information dash (Sheet 2) that runs from it and two cells (Sheet 2, K2 and K4) will be changed to show particular date ranges. At present I am trying to get how many days Mr. Smith (Sheet 2, K10) worked between (and including) 04/Feb/2014 and 10/Feb/2014 (Sheet 2, K2 and K4) based on the info below;

C AP
1 10/02/2014 Mr Smith
2 10/02/2014 Mr Smith
3 10/02/2014 Mr Smith
4 10/02/2014 Mr Smith
5 10/02/2014 Mr Smith
6 10/02/2014 Mr Smith
7 10/02/2014 Mr Smith
8 10/02/2014 Mr Smith
9 10/02/2014 Mr Smith
10 10/02/2014 Mr Smith
11 10/02/2014 Mr Smith
12 10/02/2014 Mr Smith
13 10/02/2014 Mr Smith
14 08/02/2014 Mr Smith
15 08/02/2014 Mr Smith
16 08/02/2014 Mr Smith
17 08/02/2014 Mr Smith
18 08/02/2014 Mr Smith
19 08/02/2014 Mr Smith
20 08/02/2014 Mr Smith
21 07/02/2014 Mr Smith
22 04/02/2014 Mr Smith
23 03/02/2014 Mr Smith
24 31/01/2014 Mr Smith
25 31/01/2014 Mr Smith
26 31/01/2014 Mr Smith
27 31/01/2014 Mr Smith
28 31/01/2014 Mr Smith
29 31/01/2014 Mr Smith
30 30/01/2014 Mr Smith
31 30/01/2014 Mr Smith
32 30/01/2014 Mr Smith
33 30/01/2014 Mr Smith
34 30/01/2014 Mr Smith
35 30/01/2014 Mr Smith
36 30/01/2014 Mr Smith
37 30/01/2014 Mr Smith
38 29/01/2014 Mr Smith
39 29/01/2014 Mr Smith
40 29/01/2014 Mr Smith
41 29/01/2014 Mr Smith
42 29/01/2014 Mr Smith
43 29/01/2014 Mr Smith
44 29/01/2014 Mr Smith

Hopefully this makes sense!