Spreadsheet: 201078d1355849816-how-to-tell-excell-that-other-dates-from-another-month-are-classed-as-that-month-book1
Sheet: Sheet1

Paydates |  |  |  |  |  |  |  | DATA
Month of pay | In (from) | Out (too) |  |  |  |  | amount | completed date | month payed
2011-11-01 00:00:00 | 2011-10-23 00:00:00 | 2011-11-22 00:00:00 |  |  |  |  | 408.27 | 2011-11-11 00:00:00
2011-12-01 00:00:00 | 2011-11-23 00:00:00 | 2011-12-22 00:00:00 |  |  |  |  | 1001.18 | 2011-11-09 00:00:00
2012-01-01 00:00:00 | 2011-12-23 00:00:00 | 2011-01-22 00:00:00 |  |  |  |  | 11250 | 2011-11-07 00:00:00
2012-02-01 00:00:00 | 2012-01-23 00:00:00 | 2011-02-22 00:00:00 |  |  |  |  | 2500 | 2011-12-09 00:00:00
2012-03-01 00:00:00 | 2012-02-23 00:00:00 | 2011-03-22 00:00:00 |  |  |  |  | 392.5 | 2011-11-30 00:00:00
2012-04-01 00:00:00 | 2012-03-23 00:00:00 | 2011-04-22 00:00:00 |  |  |  |  | 785 | 2011-11-29 00:00:00
2012-05-01 00:00:00 | 2012-04-23 00:00:00 | 2011-05-22 00:00:00 |  |  |  |  | 583.21 | 2011-11-28 00:00:00
2012-06-01 00:00:00 | 2012-05-23 00:00:00 | 2011-06-22 00:00:00 |  |  |  |  | 618 | 2011-11-29 00:00:00
2012-07-01 00:00:00 | 2012-06-23 00:00:00 | 2011-07-22 00:00:00 |  |  |  |  | 549.5 | 2011-12-06 00:00:00
2012-08-01 00:00:00 | 2012-07-23 00:00:00 | 2011-08-22 00:00:00 |  |  |  |  | 5000 | 2011-12-20 00:00:00
2012-09-01 00:00:00 | 2012-08-23 00:00:00 | 2011-09-22 00:00:00 |  |  |  |  | 5500 | 2011-11-22 00:00:00
2012-10-01 00:00:00 | 2012-09-23 00:00:00 | 2011-10-22 00:00:00 |  |  |  |  | 1000 | 2011-11-23 00:00:00
2012-11-01 00:00:00 | 2012-10-23 00:00:00 | 2011-11-22 00:00:00 |  |  |  |  | 1 | 2011-11-24 00:00:00
2012-12-01 00:00:00 | 2012-11-23 00:00:00 | 2011-12-22 00:00:00 |  |  |  |  |  | 2012-12-26 00:00:00
2013-01-01 00:00:00 | 2012-12-23 00:00:00 | 2013-01-22 00:00:00
2013-02-01 00:00:00 | 2013-01-23 00:00:00 | 2013-02-22 00:00:00
2013-03-01 00:00:00 | 2013-02-23 00:00:00 | 2013-03-22 00:00:00
2013-04-01 00:00:00 | 2013-03-23 00:00:00 | 2013-04-22 00:00:00
2013-05-01 00:00:00 | 2013-04-23 00:00:00 | 2013-05-22 00:00:00
2013-06-01 00:00:00 | 2013-05-23 00:00:00 | 2013-06-22 00:00:00
2013-07-01 00:00:00 | 2013-06-23 00:00:00 | 2013-07-22 00:00:00
2013-08-01 00:00:00 | 2013-07-23 00:00:00 | 2013-08-22 00:00:00
2013-09-01 00:00:00 | 2013-08-23 00:00:00 | 2013-09-22 00:00:00
2013-10-01 00:00:00 | 2013-09-23 00:00:00 | 2013-10-22 00:00:00
2013-11-01 00:00:00 | 2013-10-23 00:00:00 | 2013-11-22 00:00:00
2013-12-01 00:00:00 | 2013-11-23 00:00:00 | 2013-12-22 00:00:00
2014-01-01 00:00:00 | 2013-12-23 00:00:00 | 2014-01-22 00:00:00
2014-02-01 00:00:00 | 2014-01-23 00:00:00 | 2014-02-22 00:00:00
2014-03-01 00:00:00 | 2014-02-23 00:00:00 | 2014-03-22 00:00:00
2014-04-01 00:00:00 | 2014-03-23 00:00:00 | 2014-04-22 00:00:00
2014-05-01 00:00:00 | 2014-04-23 00:00:00 | 2014-05-22 00:00:00
2014-06-01 00:00:00 | 2014-05-23 00:00:00 | 2014-06-22 00:00:00
2014-07-01 00:00:00 | 2014-06-23 00:00:00 | 2014-07-22 00:00:00
2014-08-01 00:00:00 | 2014-07-23 00:00:00 | 2014-08-22 00:00:00
2014-09-01 00:00:00 | 2014-08-23 00:00:00 | 2014-09-22 00:00:00
2014-10-01 00:00:00 | 2014-09-23 00:00:00 | 2014-10-22 00:00:00
2014-11-01 00:00:00 | 2014-10-23 00:00:00 | 2014-11-22 00:00:00
2014-12-01 00:00:00 | 2014-11-23 00:00:00 | 2014-12-22 00:00:00
2015-01-01 00:00:00 | 2014-12-23 00:00:00 | 2015-01-23 00:00:00