Spreadsheet: 104493d1302089929-project-milestones-how-many-targets-met-per-quarter-pivot-table-with-example-projectmilestonesbydate
Sheet: Sheet2

 |  | Project Name | Next Billing Milestone (1) | Date Expected | [NAME] (2) | Date Expected | Subsequent milestone (3) | Date Expected
 |  | Project 1 | Step 2 | 2011-03-29 08:00:00 | Step 3 | 2011-07-18 17:00:00
 |  | Project 2 | Step 2 | 2011-04-05 17:00:00 | Step 3 | 2011-07-26 17:00:00
 |  | Project 3 | Step 2 | 2011-04-06 17:00:00 | Step 3 | 2011-07-27 17:00:00
 |  | Project 4 | Step 1 | 2011-04-25 17:00:00 | Step 2 | 2011-11-03 17:00:00 | Step 3 | 2012-02-23 17:00:00
 |  | Project 5 | Step 1 | 2011-04-25 17:00:00 | Step 2 | 2011-12-14 17:00:00 | Step 3 | 2012-03-27 17:00:00
 |  | Project 6 | Step 1 | 2011-05-02 17:00:00 | Step 2 | 2011-12-21 17:00:00 | Step 3 | 2012-04-03 17:00:00
 |  | Project 7 | Step 1 | 2011-05-02 17:00:00 | Step 2 | 2011-12-21 17:00:00 | Step 3 | 2012-04-03 17:00:00
 |  | Project 8 | Step 1 | 2011-05-16 17:00:00 | Step 2 | 2011-12-21 17:00:00 | Step 3 | 2012-04-11 17:00:00
 |  | Project 9 | Step 1 | 2011-06-13 17:00:00 | Step 2 | 2012-02-01 17:00:00 | Step 3 | 2012-05-15 17:00:00
 |  | Project 10 | Step 1 | 2011-06-28 17:00:00 | Step 2 | 2012-02-16 17:00:00 | Step 3 | 2012-05-30 17:00:00
 |  | Project 11 | Step 1 | 2011-06-28 17:00:00 | Step 2 | 2012-02-16 17:00:00 | Step 3 | 2012-05-30 17:00:00
 |  | Project 12 | Step 1 | 2011-06-28 17:00:00 | Step 2 | 2012-02-16 17:00:00 | Step 3 | 2012-05-30 17:00:00
 |  | Project 13 | Step 1 | 2011-07-04 17:00:00 | Step 2 | 2012-02-22 17:00:00 | Step 3 | 2012-06-05 17:00:00
 |  | Project 14 | Step 1 | 2011-07-12 17:00:00 | Step 2 | 2012-03-01 17:00:00 | Step 3 | 2012-06-13 17:00:00
 |  | Project 15 | Step 1 | 2011-07-12 17:00:00 | Step 2 | 2012-03-01 17:00:00 | Step 3 | 2012-06-13 17:00:00
 |  | Project 16 | Step 1 | 2011-07-12 17:00:00 | Step 2 | 2012-03-01 17:00:00 | Step 3 | 2012-06-13 17:00:00
 |  | Project 17 | Step 2 | 2011-08-29 17:00:00 | Step 3 | 2011-12-19 17:00:00
 |  | Project 18 | Step 2 | 2011-08-29 17:00:00 | Step 3 | 2011-12-19 17:00:00
 |  | Project 19 | Step 2 | 2011-08-29 17:00:00 | Step 2 | 2012-04-18 17:00:00 | Step 3 | 2012-07-31 17:00:00
 |  | Project 20 | Step 1 | 2011-09-12 17:00:00 | Step 2 | 2012-05-02 17:00:00 | Step 3 | 2012-08-14 17:00:00
 |  | Milestones 2011 | 30
 |  | Milestones 2012 | 25
 |  | Total | 55
 |  | 2011 Q1 | 1
 |  | 2011 Q2 | 11
 |  | 2011 Q3 | 11
 |  | 2011 Q4 | 7
 |  | 2012 Q1 | 10 |  | Question:  this method answers the question as to how many milestones in each quarter.  Could it be done better in a pivot table than these sumproducts?
 |  | 2012 Q2 | 13
 |  | 2012 Q3 | 2 |  | Question:  If I now want to ask "how many step 1, step 2 and step 3's  will be completed in each quarter until the end of 2012?
 |  | 2012 Q4 | 0 |  | I would use a countif but there are two variables (step # and date completed) so cannot.  Again, is a pivot table best to use?
 |  | Total | 55
 |  | Q1 2011 | Q2 2011 | Q3 2011 | Q4 2011
 |  | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00
 |  | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00
 |  | Q1 2012 | Q2 2012 | Q3 2012 | Q4 2012
 |  | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00
 |  | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00