Spreadsheet: 45506d1244225791-calculate-number-of-days-using-2-sets-of-dates-dates_with_formula
Sheet: dates

 |  | Days Between | Days Between | Days Between | Days Between | Days Between | Days Between | Days Between | Days Between | Days Between | Days Between |  | # Of
Period | Period | 1999-10-01 00:00:00 | 2000-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-10-01 00:00:00 | 2005-10-01 00:00:00 | 2006-10-01 00:00:00 | 2007-10-01 00:00:00 | 2008-10-01 00:00:00 | Sum | Days
Start | End | 2000-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-10-01 00:00:00 | 2005-10-01 00:00:00 | 2006-10-01 00:00:00 | 2007-10-01 00:00:00 | 2008-10-01 00:00:00 | 2009-10-01 00:00:00 | Of Days | In Period | Check
2006-01-01 00:00:00 | 2007-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 273 | 92 | 0 | 0 | 365 | 365 | OK
2000-05-15 00:00:00 | 2001-05-01 00:00:00 | 139 | 212 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 351 | 351 | OK
2000-04-01 00:00:00 | 2000-10-01 00:00:00 | 183 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 183 | OK
2000-04-01 00:00:00 | 2000-10-01 00:00:00 | 183 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 183 | OK
2000-04-01 00:00:00 | 2000-10-01 00:00:00 | 183 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 183 | OK
2000-04-01 00:00:00 | 2000-10-01 00:00:00 | 183 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 183 | OK
2001-09-26 00:00:00 | 2002-10-01 00:00:00 | 0 | 5 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 370 | 370 | OK
2001-07-26 00:00:00 | 2001-10-01 00:00:00 | 0 | 67 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 67 | 67 | OK
2000-10-01 00:00:00 | 2001-10-01 00:00:00 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2000-10-01 00:00:00 | 2001-10-01 00:00:00 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2000-10-01 00:00:00 | 2001-10-01 00:00:00 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2000-10-01 00:00:00 | 2001-10-01 00:00:00 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2000-10-01 00:00:00 | 2001-10-01 00:00:00 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2000-10-01 00:00:00 | 2001-10-01 00:00:00 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2001-10-01 00:00:00 | 2002-10-01 00:00:00 | 0 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2001-10-01 00:00:00 | 2002-10-01 00:00:00 | 0 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2001-10-01 00:00:00 | 2002-10-01 00:00:00 | 0 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2001-10-01 00:00:00 | 2002-10-01 00:00:00 | 0 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2001-10-01 00:00:00 | 2002-10-01 00:00:00 | 0 | 0 | 365 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2002-10-01 00:00:00 | 2003-04-05 00:00:00 | 0 | 0 | 0 | 186 | 0 | 0 | 0 | 0 | 0 | 0 | 186 | 186 | OK
2002-10-01 00:00:00 | 2003-04-01 00:00:00 | 0 | 0 | 0 | 182 | 0 | 0 | 0 | 0 | 0 | 0 | 182 | 182 | OK
2002-10-01 00:00:00 | 2003-04-01 00:00:00 | 0 | 0 | 0 | 182 | 0 | 0 | 0 | 0 | 0 | 0 | 182 | 182 | OK
2002-10-01 00:00:00 | 2003-04-01 00:00:00 | 0 | 0 | 0 | 182 | 0 | 0 | 0 | 0 | 0 | 0 | 182 | 182 | OK
2002-10-01 00:00:00 | 2003-04-01 00:00:00 | 0 | 0 | 0 | 182 | 0 | 0 | 0 | 0 | 0 | 0 | 182 | 182 | OK
2003-04-01 00:00:00 | 2004-04-01 00:00:00 | 0 | 0 | 0 | 183 | 183 | 0 | 0 | 0 | 0 | 0 | 366 | 366 | OK
2003-04-01 00:00:00 | 2004-04-01 00:00:00 | 0 | 0 | 0 | 183 | 183 | 0 | 0 | 0 | 0 | 0 | 366 | 366 | OK
2003-04-01 00:00:00 | 2004-04-01 00:00:00 | 0 | 0 | 0 | 183 | 183 | 0 | 0 | 0 | 0 | 0 | 366 | 366 | OK
2003-04-01 00:00:00 | 2004-04-01 00:00:00 | 0 | 0 | 0 | 183 | 183 | 0 | 0 | 0 | 0 | 0 | 366 | 366 | OK
2003-04-01 00:00:00 | 2004-04-01 00:00:00 | 0 | 0 | 0 | 183 | 183 | 0 | 0 | 0 | 0 | 0 | 366 | 366 | OK
2004-02-01 00:00:00 | 2005-02-01 00:00:00 | 0 | 0 | 0 | 0 | 243 | 123 | 0 | 0 | 0 | 0 | 366 | 366 | OK
2004-02-01 00:00:00 | 2005-02-01 00:00:00 | 0 | 0 | 0 | 0 | 243 | 123 | 0 | 0 | 0 | 0 | 366 | 366 | OK
2004-04-01 00:00:00 | 2005-04-01 00:00:00 | 0 | 0 | 0 | 0 | 183 | 182 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2004-04-01 00:00:00 | 2005-04-01 00:00:00 | 0 | 0 | 0 | 0 | 183 | 182 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2004-04-01 00:00:00 | 2005-04-01 00:00:00 | 0 | 0 | 0 | 0 | 183 | 182 | 0 | 0 | 0 | 0 | 365 | 365 | OK
2005-04-01 00:00:00 | 2006-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 183 | 182 | 0 | 0 | 0 | 365 | 365 | OK
2005-04-01 00:00:00 | 2006-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 183 | 182 | 0 | 0 | 0 | 365 | 365 | OK
2005-04-01 00:00:00 | 2006-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 183 | 182 | 0 | 0 | 0 | 365 | 365 | OK
2005-04-01 00:00:00 | 2006-03-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 183 | 180 | 0 | 0 | 0 | 363 | 363 | OK
2005-04-01 00:00:00 | 2006-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 183 | 182 | 0 | 0 | 0 | 365 | 365 | OK
2007-04-01 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 183 | 0 | 366 | 366 | OK
2006-04-01 00:00:00 | 2007-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 182 | 0 | 0 | 365 | 365 | OK
2007-04-01 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 183 | 0 | 366 | 366 | OK
2006-04-01 00:00:00 | 2007-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 182 | 0 | 0 | 365 | 365 | OK
2006-04-01 00:00:00 | 2006-11-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 31 | 0 | 0 | 214 | 214 | OK
2007-07-01 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 92 | 183 | 0 | 275 | 275 | OK
2007-07-09 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 84 | 183 | 0 | 267 | 267 | OK
2007-07-12 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 81 | 183 | 0 | 264 | 264 | OK
2007-07-03 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 90 | 183 | 0 | 273 | 273 | OK
2007-07-11 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82 | 183 | 0 | 265 | 265 | OK
2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 0 | 183 | 91 | Check
2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 0 | 183 | 91 | Check
2008-01-02 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 0 | 183 | 90 | Check
2008-01-03 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 0 | 183 | 89 | Check
2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 0 | 183 | 91 | Check