Spreadsheet: 188986d1351049179-excel-2007-pivot-tables-counting-dates-help-needed-sample-workbook-visits
Sheet: test sample

Patient # | Site # | Last Name | V2 | V3 | V4 | V5 | V6 | V6a | V7 | V7a | V8 | V8a | V9 | [NAME] | V10 | V10a | V11 | V11a | V12 | V12a | V13 | V13a | V14 | V14a | V15 | V15a | V16 | V16a | V17 | V17a | V18 | V18a | V19 | V19a | V20 | V20a | V21 | V21a | V22 | V22a | V23 | V23A | V24 | V24a | V25 | V25a | V26 | V26a | ET | ET4
1 | 1 | A | 2012-08-17 00:00:00
2 | 1 | A | 2012-10-24 00:00:00
3 | 1 | A | 2012-10-10 00:00:00
4 | 1 | A | 2012-09-27 00:00:00
5 | 1 | A | 2012-10-31 00:00:00
6 | 2 | B | 2012-09-27 00:00:00
 | 2 | B | 2012-11-09 00:00:00
 | 2 | B | 2013-04-12 00:00:00
 | 2 | B | 2013-05-17 00:00:00
 | 2 | B | 2013-06-04 00:00:00
 | 2 | B | 2013-05-30 00:00:00
 | 3 | C | 2012-12-31 00:00:00
 | 3 | C | 2013-03-26 00:00:00
 | 3 | C | 2013-05-27 00:00:00
 | 4 | D | 2013-05-16 00:00:00
 | 5 | E | 2013-04-19 00:00:00
 | 6 | F | 2013-07-01 00:00:00
 | 7 | G | 2013-04-08 00:00:00
 | 7 | G | 2013-05-31 00:00:00
 | 7 | G | 2013-06-03 00:00:00
 | 8 | H | 2013-03-19 00:00:00
 | 8 | H | 2013-03-26 00:00:00
 | 8 | H | 2013-04-09 00:00:00
 | 8 | H | 2013-04-02 00:00:00
 | 8 | H | 2013-04-23 00:00:00
 | 8 | H | 2013-04-30 00:00:00
 | 8 | H | 2013-06-25 00:00:00
 | 8 | H | 2013-05-17 00:00:00
 | 9 | I | 2013-03-08 00:00:00
 | 10 | J | 2013-05-27 00:00:00
 | 11 | K | 2013-01-15 00:00:00
 | 12 | L | 2013-03-06 00:00:00
 | 12 | L | 2013-05-06 00:00:00
 | 12 | L | 2013-06-26 00:00:00
 | 12 | L | 2013-06-21 00:00:00
 | 13 | M | 2013-01-02 00:00:00
 | 13 | M | 2013-02-04 00:00:00
 | 13 | M | 2013-02-21 00:00:00
 | 13 | M | 2013-02-27 00:00:00
 | 13 | N | 2012-10-12 00:00:00
 | 13 | N | 2013-01-16 00:00:00
 | 13 | N | 2013-01-08 00:00:00
 | 13 | N | 2013-04-05 00:00:00
 | 13 | N | 2013-04-26 00:00:00
 | 14 | O | 2012-08-02 00:00:00
 | 14 | O | 2012-08-31 00:00:00
 | 14 | O | 2012-10-23 00:00:00
 | 14 | O | 2012-12-14 00:00:00
 | 14 | O | 2013-01-15 00:00:00
 | 14 | O | 2013-01-30 00:00:00
 | 14 | O | 2013-05-20 00:00:00
 | 14 | O | 2012-11-12 00:00:00
 | 15 | P | 2013-02-13 00:00:00
 | 15 | P | 2012-11-01 00:00:00
 | 15 | P | 2012-10-22 00:00:00
 | 15 | P | 2012-11-28 00:00:00
 | 15 | P | 2013-01-03 00:00:00
 | 15 | P | 2013-03-14 00:00:00
 | 15 | P | 2013-03-29 00:00:00
 | 16 | Q | 2012-08-02 00:00:00
 | 16 | Q | 2012-08-03 00:00:00
 | 16 | Q | 2012-10-17 00:00:00
 | 16 | Q | 2012-08-17 00:00:00
 | 16 | Q | 2012-08-06 00:00:00
 | 16 | Q | 2012-09-04 00:00:00
 | 16 | Q | 2012-09-05 00:00:00
 | 16 | Q | 2012-10-16 00:00:00
 | 16 | Q | 2013-01-15 00:00:00
 | 16 | Q | 2013-02-27 00:00:00
 | 16 | Q | 2013-07-02 00:00:00
 | 16 | Q | 2013-05-22 00:00:00
 | 16 | Q | 2013-05-28 00:00:00
 | 16 | Q | 2013-05-22 00:00:00
 | 17 | R | 2013-07-02 00:00:00
 | 18 | S | 2012-09-17 00:00:00
 | 18 | S | 2012-12-19 00:00:00
 | 19 | T | 2013-05-28 00:00:00
 | 19 | T | 2013-06-03 00:00:00
 | 20 | U | 2013-05-17 00:00:00
 | 20 | U | 2013-05-09 00:00:00
 | 21 | V | 2013-06-12 00:00:00
 | 21 | V | 2013-07-09 00:00:00
 | 21 | V | 2013-07-01 00:00:00
 | 22 | W | 2012-08-27 00:00:00
 | 22 | W | 2012-10-02 00:00:00
 | 22 | W | 2012-10-16 00:00:00
 | 22 | W | 2012-09-27 00:00:00
 | 22 | W | 2012-12-19 00:00:00
 | 22 | W | 2013-03-21 00:00:00
 | 23 | X | 2013-07-03 00:00:00
 | 23 | X | 2013-07-12 00:00:00
 | 24 | Y | 2013-04-12 00:00:00
 | 24 | Y | 2013-05-15 00:00:00
 | 24 | Y | 2013-07-08 00:00:00
 | 24 | Y | 2013-06-05 00:00:00
 | 25 | Z | 2013-04-24 00:00:00
 | 26 | AA | 2013-03-15 00:00:00
 | 26 | AB | 2013-05-10 00:00:00
 | 26 | AB | 2013-05-30 00:00:00
 | 26 | AB | 2013-06-03 00:00:00
 | 27 | AC | 2013-04-15 00:00:00
 | 27 | AC | 2013-05-10 00:00:00
 | 27 | AC | 2013-05-20 00:00:00
 | 28 | AD | 2012-10-30 00:00:00
 | 28 | AD | 2012-12-26 00:00:00
 | 28 | AD | 2013-02-08 00:00:00
 | 29 | AE | 2013-04-24 00:00:00
 | 29 | AE | 2013-05-10 00:00:00
 | 30 | AF | 2013-06-14 00:00:00
 | 30 | AF | 2013-05-21 00:00:00
 | 31 | AG | 2013-01-22 00:00:00
 | 31 | AG | 2013-02-01 00:00:00
 | 32 | AH | 2012-11-23 00:00:00
 | 32 | AH | 2012-12-25 00:00:00
 | 32 | AH | 2013-02-14 00:00:00
 | 32 | AH | 2013-02-28 00:00:00
 | 32 | AH | 2013-05-02 00:00:00
 | 32 | AH | 2013-05-06 00:00:00
 | 33 | AI | 2013-05-07 00:00:00
 | 33 | AI | 2013-05-02 00:00:00
 | 34 | AJ | 2013-02-04 00:00:00
 | 34 | AJ | 2013-03-26 00:00:00
 | 35 | AK | 2013-01-02 00:00:00
 | 36 | AL | 2012-11-07 00:00:00
 | 37 | AM | 2012-10-05 00:00:00
 | 37 | AM | 2013-01-03 00:00:00
 | 37 | AM | 2013-02-07 00:00:00
 | 38 | AN | 2013-03-25 00:00:00
 | 38 | AN | 2013-03-28 00:00:00
 | 39 | AO | 2013-03-21 00:00:00
 | 39 | AO | 2013-01-29 00:00:00
 | 40 | AP | 2012-11-20 00:00:00
 | 41 | AQ | 2013-03-29 00:00:00
 | 41 | AQ | 2013-05-22 00:00:00
 | 42 | AR | 2012-08-13 00:00:00
 | 42 | AR | 2012-09-11 00:00:00
 | 43 | AS | 2012-11-20 00:00:00
 | 43 | AS | 2013-04-01 00:00:00
 |  |  | Total  2013 # visits | [NAME]. | Qtrly Total | Total 2014 # visits | [NAME]. | Qtrly Total | Total 2015 # visits | Total 2016 # visits | Total 2017 # visits | Total 2018 # visits
 |  | Jan
 |  | Feb
 |  | Mar
 |  | Apr
 |  | May
 |  | Jun
 |  | Jul
 |  | Aug
 |  | Sep
 |  | Oct
 |  | Nov
 |  | Dec
 |  | Grand Total
 |  | With 10% drop 2013 and 2014 With 50% drop 2015 onward