Spreadsheet: 144551d1331037893-date-calculation-date-calculation
Sheet: Sheet1

Start date | End date | No. of months in Year 2010 | No. of months in Year 2011 | No. of months in Year 2012 | Total duration
2010-05-25 00:00:00 | 2012-01-31 00:00:00 | 7 | 12 | 1
2010-05-25 00:00:00 | 2012-01-31 00:00:00 | 7 | 12 | 1
2011-04-21 00:00:00 | 2012-01-31 00:00:00 | 0 | 8 | 1
2010-08-17 00:00:00 | 2012-01-31 00:00:00 | 4 | 12 | 1
2010-11-02 00:00:00 | 2012-01-31 00:00:00 | 2 | 12 | 1
2011-02-15 00:00:00 | 2012-01-31 00:00:00 | 0 | 11 | 1
2010-09-20 00:00:00 | 2010-10-30 00:00:00 | 1 | 0 | 0
2010-05-25 00:00:00 |  | 0 | 0 | 0
2012-01-25 00:00:00 | 2012-01-31 00:00:00 | 0 | 0 | 0
2010-08-17 00:00:00 |  | 0 | 0 | 0
2012-01-09 00:00:00 | 2012-01-31 00:00:00 | 0 | 0 | 1
2011-01-24 00:00:00 | 2012-01-31 00:00:00 | 0 | 11 | 1
2010-02-22 00:00:00 | 2012-01-31 00:00:00 | 10 | 12 | 1
2010-05-25 00:00:00 | 2010-10-06 00:00:00 | 4 | 0 | 0
2011-11-04 00:00:00 | 2012-01-31 00:00:00 | 0 | 2 | 1
2011-06-16 00:00:00 | 2012-01-31 00:00:00 | 0 | 7 | 1
2012-01-09 00:00:00 | 2012-01-31 00:00:00 | 0 | 0 | 1
2010-11-30 00:00:00 | 2011-01-18 00:00:00 | 1 | 11 | 0
2010-12-29 00:00:00 | 2012-01-31 00:00:00 | 0 | 12 | 1
2010-06-16 00:00:00 | 2012-01-31 00:00:00 | 7 | 12 | 1
2010-07-02 00:00:00 | 2011-08-09 00:00:00 | 6 | 7 | 0
2010-06-29 00:00:00 | 2012-01-31 00:00:00 | 6 | 12 | 1
2010-02-09 00:00:00 | 2012-01-31 00:00:00 | 10 | 12 | 1
2010-06-16 00:00:00 | 2012-01-31 00:00:00 | 7 | 12 | 1
2010-08-12 00:00:00 | 2012-01-31 00:00:00 | 5 | 12 | 1
2010-10-19 00:00:00 | 2012-01-31 00:00:00 | 2 | 12 | 1
2010-09-13 00:00:00 | 2012-01-31 00:00:00 | 4 | 12 | 1
2010-08-09 00:00:00 | 2010-08-09 00:00:00 | 0 | 0 | 0
2011-01-05 00:00:00 | 2012-01-31 00:00:00 | 0 | 12 | 1
2011-01-05 00:00:00 | 2012-01-31 00:00:00 | 0 | 12 | 1
2010-11-02 00:00:00 | 2012-01-31 00:00:00 | 2 | 12 | 1
2010-02-15 00:00:00 | 2012-01-31 00:00:00 | 10 | 12 | 1
2011-03-18 00:00:00 | 2012-01-31 00:00:00 | 0 | 9 | 1
2010-02-11 00:00:00 | 2012-01-31 00:00:00 | 10 | 12 | 1
2011-05-09 00:00:00 | 2012-01-31 00:00:00 | 0 | 8 | 1
2011-02-01 00:00:00 | 2012-01-31 00:00:00 | 0 | 11 | 1
2010-11-10 00:00:00 | 2012-01-31 00:00:00 | 2 | 12 | 1
2010-02-17 00:00:00 | 2011-05-04 00:00:00 | 10 | 8 | 0
2010-07-02 00:00:00 | 2011-06-07 00:00:00 | 6 | 7 | 0
2010-11-30 00:00:00 | 2012-01-31 00:00:00 | 1 | 12 | 1
2010-12-02 00:00:00 | 2012-01-31 00:00:00 | 1 | 12 | 1
2010-05-25 00:00:00 | 2010-06-09 00:00:00 | 1 | 0 | 0
2011-06-21 00:00:00 | 2012-01-31 00:00:00 | 0 | 6 | 1
2010-06-02 00:00:00 | 2011-01-29 00:00:00 | 7 | 11 | 0
2012-01-21 00:00:00 | 2012-01-31 00:00:00 | 0 | 0 | 0
2010-10-19 00:00:00 | 2010-12-07 00:00:00 | 2 | 0 | 0
2010-11-30 00:00:00 | 2012-01-31 00:00:00 | 1 | 12 | 1
2011-01-18 00:00:00 | 2012-01-31 00:00:00 | 0 | 11 | 1
2010-04-08 00:00:00 | 2012-01-31 00:00:00 | 9 | 12 | 1
2011-05-27 00:00:00 | 2012-01-31 00:00:00 | 0 | 7 | 1
2010-07-28 00:00:00 | 2010-12-18 00:00:00 | 4 | 0 | 0
2010-05-25 00:00:00 | 2012-01-31 00:00:00 | 7 | 12 | 1
2010-07-02 00:00:00 | 2011-08-09 00:00:00 | 6 | 7 | 0
2010-07-02 00:00:00 | 2010-07-21 00:00:00 | 1 | 0 | 0
2010-09-14 00:00:00 | 2012-01-31 00:00:00 | 4 | 12 | 1
2010-10-04 00:00:00 | 2010-11-22 00:00:00 | 2 | 0 | 0
2011-11-21 00:00:00 | 2011-11-22 00:00:00 | 0 | 0 | 0
2012-01-21 00:00:00 | 2012-01-31 00:00:00 | 0 | 0 | 0
2010-06-02 00:00:00 |  | 0 | 0 | 0
2010-12-06 00:00:00 | 2011-03-25 00:00:00 | 1 | 9 | 0
2010-12-29 00:00:00 | 2012-01-31 00:00:00 | 0 | 12 | 1
2010-08-26 00:00:00 | 2012-01-31 00:00:00 | 4 | 12 | 1
2012-01-25 00:00:00 | 2012-01-31 00:00:00 | 0 | 0 | 0
2011-08-09 00:00:00 | 2011-08-09 00:00:00 | 0 | 0 | 0
2010-09-23 00:00:00 | 2010-10-29 00:00:00 | 1 | 0 | 0
2010-06-29 00:00:00 | 2012-01-31 00:00:00 | 6 | 12 | 1
2010-05-25 00:00:00 | 2010-11-16 00:00:00 | 6 | 0 | 0
2010-05-28 00:00:00 | 2010-10-29 00:00:00 | 5 | 0 | 0
2010-08-17 00:00:00 | 2012-01-31 00:00:00 | 4 | 12 | 1
2010-09-27 00:00:00 | 2010-12-22 00:00:00 | 3 | 0 | 0
2011-02-08 00:00:00 | 2012-01-31 00:00:00 | 0 | 11 | 1
2010-08-26 00:00:00 | 2012-01-31 00:00:00 | 4 | 12 | 1
2011-11-09 00:00:00 | 2012-01-21 00:00:00 | 0 | 2 | 1
2011-08-17 00:00:00 | 2012-01-02 00:00:00 | 0 | 4 | 0
2010-05-29 00:00:00 | 2010-06-09 00:00:00 | 0 | 0 | 0
2011-11-04 00:00:00 | 2012-01-31 00:00:00 | 0 | 2 | 1
2010-05-25 00:00:00 | 2012-01-31 00:00:00 | 7 | 12 | 1
2011-11-04 00:00:00 | 2012-01-31 00:00:00 | 0 | 2 | 1
2010-10-06 00:00:00 | 2012-01-31 00:00:00 | 3 | 12 | 1
2010-11-02 00:00:00 |  | 0 | 0 | 0
2011-06-03 00:00:00 | 2011-09-26 00:00:00 | 0 | 4 | 0
2011-11-09 00:00:00 | 2012-01-21 00:00:00 | 0 | 2 | 1
2010-06-02 00:00:00 | 2012-01-31 00:00:00 | 7 | 12 | 1
2010-12-21 00:00:00 | 2012-01-31 00:00:00 | 0 | 12 | 1
2012-01-25 00:00:00 | 2012-01-31 00:00:00 | 0 | 0 | 0
2012-01-25 00:00:00 | 2012-01-31 00:00:00 | 0 | 0 | 0
2010-02-09 00:00:00 | 2012-01-31 00:00:00 | 11 | 12 | 1
2011-08-18 00:00:00 | 2012-01-31 00:00:00 | 0 | 4 | 1
2011-07-06 00:00:00 | 2012-01-31 00:00:00 | 0 | 6 | 1
2010-12-21 00:00:00 | 2012-01-31 00:00:00 | 0 | 12 | 1
2010-02-15 00:00:00 | 2012-01-31 00:00:00 | 11 | 12 | 1
2010-10-04 00:00:00 | 2011-06-02 00:00:00 | 3 | 7 | 0
2012-01-09 00:00:00 | 2012-01-31 00:00:00 | 0 | 0 | 1
2010-06-29 00:00:00 |  | 0 | 0 | 0
2012-01-25 00:00:00 | 2012-01-31 00:00:00 | 0 | 0 | 0
2010-06-29 00:00:00 | 2010-09-30 00:00:00 | 3 | 0 | 0
2011-01-31 00:00:00 | 2012-01-31 00:00:00 | 0 | 11 | 1
2011-06-16 00:00:00 | 2012-01-31 00:00:00 | 0 | 7 | 1
2011-11-04 00:00:00 | 2012-01-31 00:00:00 | 0 | 2 | 1
2010-05-25 00:00:00 | 2012-01-31 00:00:00 | 7 | 12 | 1
2010-06-16 00:00:00 | 2012-01-31 00:00:00 | 7 | 12 | 1
2010-04-08 00:00:00 | 2012-01-31 00:00:00 | 8 | 12 | 1
2010-07-02 00:00:00 | 2010-07-09 00:00:00 | 0 | 0 | 0
2010-11-02 00:00:00 |  | 0 | 0 | 0
2010-06-18 00:00:00 | 2012-01-02 00:00:00 | 6 | 12
2011-02-28 00:00:00 | 2011-09-02 00:00:00 | 0 | 6 | 0
2011-06-16 00:00:00 | 2011-12-15 00:00:00 | 0 | 6 | 0
2011-12-15 00:00:00 | 2012-01-31 00:00:00 | 0 | 1 | 1
2010-05-31 00:00:00 | 2012-01-31 00:00:00 | 7 | 12 | 1
2011-11-04 00:00:00 | 2012-01-31 00:00:00 | 0 | 2 | 1