Spreadsheet: 287107d1388653593-conditional-formatting-dates-calculation-sample
Sheet: Contract activity

Start | End | Renewal
2009-04-01 01:00:00 | 2013-01-31 00:00:00 | 2013-02-01 00:00:00
2010-07-06 01:00:00 | 2014-09-30 01:00:00 | 2014-10-01 01:00:00
2009-01-05 00:00:00 | 2013-12-31 00:00:00 | 2014-01-01 00:00:00
2010-02-01 00:00:00 | 2013-06-30 01:00:00 | 2013-07-01 01:00:00
2007-11-01 00:00:00 | 2011-09-30 01:00:00 | 2011-09-30 01:00:00
2007-05-01 01:00:00 | 2012-12-31 00:00:00 | 2012-10-01 01:00:00
2010-02-01 00:00:00 | 2014-01-31 00:00:00 | 2014-02-01 00:00:00
2007-05-01 01:00:00 | 2012-04-30 01:00:00 | 2012-05-01 01:00:00
2010-07-06 01:00:00 | 2013-01-31 00:00:00 | 2013-01-31 00:00:00
2010-02-01 00:00:00 | 2013-01-31 00:00:00 | 2013-01-31 00:00:00
2011-01-01 00:00:00 | 2013-12-31 00:00:00 | 2014-06-01 01:00:00
2010-11-01 00:00:00 | 2014-10-31 00:00:00 | 2014-11-01 00:00:00
2012-10-01 01:00:00 | 2015-09-30 01:00:00 | 2015-10-01 01:00:00
2011-02-01 00:00:00 | 2016-01-31 00:00:00 | 2016-02-01 00:00:00
2012-12-01 00:00:00 | 2015-11-30 00:00:00 | 2015-12-01 00:00:00
2011-11-30 00:00:00 | 2014-11-29 00:00:00 | 2014-11-30 00:00:00
2009-10-01 01:00:00 | 2011-09-30 01:00:00 | 2013-10-01 01:00:00
2010-05-01 01:00:00 | 2014-04-30 01:00:00 | 2014-05-01 01:00:00
2013-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-01-01 00:00:00
2008-10-01 01:00:00 | 2013-09-30 01:00:00 | 2013-10-01 01:00:00
2012-11-01 00:00:00 | 2013-04-30 01:00:00 | 2013-05-01 01:00:00
2012-11-05 00:00:00 | 2013-11-04 00:00:00 | 2013-11-05 00:00:00
2010-07-22 01:00:00 | 2011-07-21 01:00:00 | 2011-07-22 01:00:00
2012-09-05 01:00:00 | 2016-02-29 00:00:00 | 2016-03-01 00:00:00
1999-07-01 01:00:00 | 2004-06-30 01:00:00 | 2004-06-30 01:00:00
2012-03-06 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00
2010-09-17 01:00:00 | 2012-09-16 01:00:00 | 2012-09-17 01:00:00
2011-02-01 00:00:00 | 2012-01-31 00:00:00
2010-10-25 01:00:00 | 2014-10-24 01:00:00 | 2014-10-25 01:00:00
2013-08-01 01:00:00 | 2017-07-31 01:00:00 | 2017-08-01 01:00:00
2013-08-01 01:00:00 | 2017-07-31 01:00:00 | 2017-08-01 01:00:00
2013-08-01 01:00:00 | 2017-07-31 01:00:00 | 2017-08-01 01:00:00
2007-09-01 01:00:00 | 2013-07-31 01:00:00 | 2013-08-01 01:00:00
2007-09-01 01:00:00 | 2013-04-30 01:00:00 | 2013-05-01 01:00:00
2009-07-01 01:00:00 | 2013-12-31 00:00:00 | 2014-01-01 00:00:00
2010-07-06 01:00:00 | 2014-09-30 01:00:00 | 2014-10-01 01:00:00
2009-03-01 00:00:00 | 2012-02-29 00:00:00 | 2012-03-01 00:00:00
2013-01-11 00:00:00 | 2015-01-10 00:00:00 | 2015-01-11 00:00:00
2013-07-15 01:00:00 | 2016-03-31 01:00:00 | 2016-04-01 01:00:00
2012-07-11 01:00:00 | 2013-01-10 00:00:00 | 2012-10-31 00:00:00
2007-05-01 01:00:00 | 2013-03-31 00:00:00 | 2013-04-01 01:00:00
2007-02-01 00:00:00 | 2010-01-31 00:00:00 | 2012-01-31 00:00:00
2010-07-01 01:00:00 | 2014-06-30 01:00:00 | 2014-07-01 01:00:00
2007-04-01 01:00:00 | 2012-03-31 01:00:00 | 2011-10-03 01:00:00
2013-09-01 01:00:00 | 2016-08-30 01:00:00 | 2016-09-01 01:00:00
2008-08-01 01:00:00 | 2013-07-31 01:00:00 | 2013-08-01 01:00:00
2012-12-01 00:00:00 | 2015-11-30 00:00:00 | 2015-12-01 00:00:00
2009-01-12 00:00:00 | 2014-01-11 00:00:00 | 2014-01-12 00:00:00
2008-08-01 01:00:00 | 2013-07-31 01:00:00 | 2013-08-01 01:00:00