Spreadsheet: 161096d1339416344-excel-2007-formula-which-finds-months-last-working-day-sums-mon-results-divide-by-monthly-targ-monthly-results
Sheet: Data

 |  |  |  |  |  |  |  | Monthly Target
 |  |  |  |  |  |  |  | 100000
 |  |  |  |  |  |  |  | Monthly Results
 |  |  |  | Time                  % | Working              Days | Date | Result | € | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holidays
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-06 00:00:00
 |  |  |  |  |  |  | 6000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-27 00:00:00
 |  |  |  |  |  |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-25 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-13 00:00:00
 |  |  |  |  |  |  | -8000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-16 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00
 |  |  |  |  |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-04 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-15 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-28 00:00:00
 |  |  |  |  |  |  | 6000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-24 00:00:00
 |  |  |  |  |  |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-25 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-26 00:00:00
 |  |  |  |  |  |  | -8000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-06 00:00:00
 |  |  |  |  |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-18 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-25 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-01 00:00:00
 |  |  |  |  |  |  | 6000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-03 00:00:00
 |  |  |  |  |  |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-06 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-06-24 00:00:00
 |  |  |  |  |  |  | -8000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-08-15 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-02 00:00:00
 |  |  |  |  |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-12-24 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-12-25 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-12-16 00:00:00
 |  |  |  |  |  |  | 6000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
 |  |  |  |  |  |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-01-06 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-03-03 00:00:00
 |  |  |  |  |  |  | -8000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-03-25 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-04-18 00:00:00
 |  |  |  |  |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-04-21 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-05-01 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-06-09 00:00:00
 |  |  |  |  |  |  | 6000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-08-15 00:00:00
 |  |  |  |  |  |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-10-20 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-12-24 00:00:00
 |  |  |  |  |  |  | -8000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-12-25 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-12-26 00:00:00
 |  |  |  |  |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-01-01 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-01-06 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-02-23 00:00:00
 |  |  |  |  |  |  | 6000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-03-25 00:00:00
 |  |  |  |  |  |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-04-10 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-04-13 00:00:00
 |  |  |  |  |  |  | -8000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-05-01 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-06-01 00:00:00
 |  |  |  |  |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-08-15 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-10-02 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-12-24 00:00:00
 |  |  |  |  |  |  | 6000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-12-25 00:00:00
 |  |  |  |  |  |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-12-26 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00
 |  |  |  |  |  |  | -8000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-01-06 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-03-11 00:00:00
 |  |  |  |  |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-03-25 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-04-29 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00
 |  |  |  |  |  |  | 6000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-05-02 00:00:00
 |  |  |  |  |  |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-06-10 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-08-15 00:00:00
 |  |  |  |  |  |  | -8000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-10-28 00:00:00
 |  |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-12-24 00:00:00
 |  |  |  |  |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-12-25 00:00:00
 |  |  |  |  |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-12-26 00:00:00
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | -5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | -8000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 6000
 |  |  |  | Interval                   Today                     % | Interval                        Working Days | Interval                   Last                                 Date