Spreadsheet: 104649d1302173388-project-milestones-how-many-targets-met-per-quarter-pivot-table-with-example-projectmilestonesbydate
Sheet: Data

 | Project Name | Next Billing Milestone (1) | Date Expected | Quarter | Milestone
 | Project-1 | Step 2 | 2011-03-29 08:00:00 | 2011-Q1 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-1 |  | Step 1
 | Project-2 | Step 2 | 2011-04-05 17:00:00 | 2011-Q2 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-2 |  | Step 2
 | Project-3 | Step 2 | 2011-04-06 17:00:00 | 2011-Q2 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-3 |  | Step 3
 | Project-4 | Step 1 | 2011-04-25 17:00:00 | 2011-Q2 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-4
 | Project-5 | Step 1 | 2011-04-25 17:00:00 | 2011-Q2 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-5
 | Project-6 | Step 1 | 2011-05-02 17:00:00 | 2011-Q2 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-6
 | Project-7 | Step 1 | 2011-05-02 17:00:00 | 2011-Q2 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-7
 | Project-8 | Step 1 | 2011-05-16 17:00:00 | 2011-Q2 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-8
 | Project-9 | Step 1 | 2011-06-13 17:00:00 | 2011-Q2 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-9
 | Project-10 | Step 1 | 2011-06-28 17:00:00 | 2011-Q2 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-10
 | Project-11 | Step 1 | 2011-06-28 17:00:00 | 2011-Q2 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-11
 | Project-12 | Step 1 | 2011-06-28 17:00:00 | 2011-Q2 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-12
 | Project-13 | Step 1 | 2011-07-04 17:00:00 | 2011-Q3 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-13
 | Project-14 | Step 1 | 2011-07-12 17:00:00 | 2011-Q3 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-14
 | Project-15 | Step 1 | 2011-07-12 17:00:00 | 2011-Q3 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-15
 | Project-16 | Step 1 | 2011-07-12 17:00:00 | 2011-Q3 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-16
 | Project-17 | Step 2 | 2011-08-29 17:00:00 | 2011-Q3 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-17
 | Project-18 | Step 2 | 2011-08-29 17:00:00 | 2011-Q3 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-18
 | Project-19 | Step 2 | 2011-08-29 17:00:00 | 2011-Q3 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-19
 | Project-20 | Step 1 | 2011-09-12 17:00:00 | 2011-Q3 | M1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project-20
 | Project-1 | Step 3 | 2011-07-18 17:00:00 | 2011-Q3 | M2 |  |  |  |  | 2011-Q1 | 2011-Q2 | 2011-Q3 | 2011-Q4
 | Project-2 | Step 3 | 2011-07-26 17:00:00 | 2011-Q3 | M2 |  |  |  |  | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00
 | Project-3 | Step 3 | 2011-07-27 17:00:00 | 2011-Q3 | M2 |  |  |  |  | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00
 | Project-4 | Step 2 | 2011-11-03 17:00:00 | 2011-Q4 | M2
 | Project-5 | Step 2 | 2011-12-14 17:00:00 | 2011-Q4 | M2 |  |  |  |  | 2012-Q1 | 2012-Q2 | 2012-Q3 | 2012-Q4
 | Project-6 | Step 2 | 2011-12-21 17:00:00 | 2011-Q4 | M2 |  |  |  |  | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00
 | Project-7 | Step 2 | 2011-12-21 17:00:00 | 2011-Q4 | M2 |  |  |  |  | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00
 | Project-8 | Step 2 | 2011-12-21 17:00:00 | 2011-Q4 | M2
 | Project-9 | Step 2 | 2012-02-01 17:00:00 | 2012-Q1 | M2
 | Project-10 | Step 2 | 2012-02-16 17:00:00 | 2012-Q1 | M2
 | Project-11 | Step 2 | 2012-02-16 17:00:00 | 2012-Q1 | M2
 | Project-12 | Step 2 | 2012-02-16 17:00:00 | 2012-Q1 | M2
 | Project-13 | Step 2 | 2012-02-22 17:00:00 | 2012-Q1 | M2
 | Project-14 | Step 2 | 2012-03-01 17:00:00 | 2012-Q1 | M2
 | Project-15 | Step 2 | 2012-03-01 17:00:00 | 2012-Q1 | M2
 | Project-16 | Step 2 | 2012-03-01 17:00:00 | 2012-Q1 | M2
 | Project-17 | Step 3 | 2011-12-19 17:00:00 | 2011-Q4 | M2
 | Project-18 | Step 3 | 2011-12-19 17:00:00 | 2011-Q4 | M2
 | Project-19 | Step 2 | 2012-04-18 17:00:00 | 2012-Q2 | M2
 | Project-20 | Step 2 | 2012-05-02 17:00:00 | 2012-Q2 | M2
 | Project-4 | Step 3 | 2012-02-23 17:00:00 | 2012-Q1 | M3
 | Project-5 | Step 3 | 2012-03-27 17:00:00 | 2012-Q1 | M3
 | Project-6 | Step 3 | 2012-04-03 17:00:00 | 2012-Q2 | M3
 | Project-7 | Step 3 | 2012-04-03 17:00:00 | 2012-Q2 | M3
 | Project-8 | Step 3 | 2012-04-11 17:00:00 | 2012-Q2 | M3
 | Project-9 | Step 3 | 2012-05-15 17:00:00 | 2012-Q2 | M3
 | Project-10 | Step 3 | 2012-05-30 17:00:00 | 2012-Q2 | M3
 | Project-11 | Step 3 | 2012-05-30 17:00:00 | 2012-Q2 | M3
 | Project-12 | Step 3 | 2012-05-30 17:00:00 | 2012-Q2 | M3
 | Project-13 | Step 3 | 2012-06-05 17:00:00 | 2012-Q2 | M3
 | Project-14 | Step 3 | 2012-06-13 17:00:00 | 2012-Q2 | M3
 | Project-15 | Step 3 | 2012-06-13 17:00:00 | 2012-Q2 | M3
 | Project-16 | Step 3 | 2012-06-13 17:00:00 | 2012-Q2 | M3
 | Project-19 | Step 3 | 2012-07-31 17:00:00 | 2012-Q3 | M3
 | Project-20 | Step 3 | 2012-08-14 17:00:00 | 2012-Q3 | M3