Spreadsheet: 724839d1616414466-returning-value-from-last-52-cells-removing-the-cells-with-no-value-new-microsoft-excel-worksheet
Sheet: Sheet1

Pay
Week Commencing | 2020-03-09 00:00:00 | 2020-03-16 00:00:00 | 2020-03-23 00:00:00 | 2020-03-30 00:00:00 | 2020-04-06 00:00:00 | 2020-04-13 00:00:00 | 2020-04-20 00:00:00 | 2020-04-27 00:00:00 | 2020-05-04 00:00:00 | 2020-05-11 00:00:00 | 2020-05-18 00:00:00 | 2020-05-25 00:00:00 | 2020-06-01 00:00:00 | 2020-06-08 00:00:00 | 2020-06-15 00:00:00 | 2020-06-22 00:00:00 | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-13 00:00:00 | 2020-07-20 00:00:00 | 2020-07-27 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 2020-08-17 00:00:00 | 2020-08-24 00:00:00 | 2020-08-31 00:00:00 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00 | 2020-09-28 00:00:00 | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00 | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00 | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 | 2021-01-18 00:00:00 | 2021-01-25 00:00:00 | 2021-02-01 00:00:00 | 2021-02-08 00:00:00 | 2021-02-15 00:00:00 | 2021-02-22 00:00:00 | 2021-03-01 00:00:00 | 2021-03-08 00:00:00 | 2021-03-15 00:00:00 | 2021-03-22 00:00:00 | 2021-03-29 00:00:00 | 2021-04-05 00:00:00 | 2021-04-12 00:00:00 | 2021-04-19 00:00:00 | 2021-04-26 00:00:00 | 2021-05-03 00:00:00 | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | 2021-05-24 00:00:00 | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-21 00:00:00 | 2021-06-28 00:00:00 | 2021-07-05 00:00:00 | 2021-07-12 00:00:00 | 2021-07-19 00:00:00 | 2021-07-26 00:00:00 | 2021-08-02 00:00:00 | 2021-08-09 00:00:00 | 2021-08-16 00:00:00 | 2021-08-23 00:00:00 | 2021-08-30 00:00:00 | 2021-09-06 00:00:00 | 2021-09-13 00:00:00 | 2021-09-20 00:00:00 | 2021-09-27 00:00:00 | 2021-10-04 00:00:00 | 2021-10-11 00:00:00 | 2021-10-18 00:00:00 | 2021-10-25 00:00:00 | 2021-11-01 00:00:00
Employee 1 | 1200 | 1100 | 1500 | 1300 | 1400 | 1500 | 1200 | 1100 | 1500 | 1300 | 1400 | 1500 | 0 | 800 | 950 | 1050 | 800 | 825 | 900 | 1500 | 1300 | 1400 | 1050 | 800 | 0 | 900 | 1500 | 1300 | 1400 | 1050 | 800 | 825 | 900 | 1500 | 1300 | 1400 | 1050 | 800 | 825 | 900 | 1500 | 1300 | 1400 | 1050 | 800 | 825 | 900 | 1500 | 1300 | 1400 | 1050 |  | 825 | 900 | 950
Week Included
Week Commencing | 2020-03-09 00:00:00 | 2020-03-16 00:00:00 | 2020-03-23 00:00:00 | 2020-03-30 00:00:00 | 2020-04-06 00:00:00 | 2020-04-13 00:00:00 | 2020-04-20 00:00:00 | 2020-04-27 00:00:00 | 2020-05-04 00:00:00 | 2020-05-11 00:00:00 | 2020-05-18 00:00:00 | 2020-05-25 00:00:00 | 2020-06-01 00:00:00 | 2020-06-08 00:00:00 | 2020-06-15 00:00:00 | 2020-06-22 00:00:00 | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-13 00:00:00 | 2020-07-20 00:00:00 | 2020-07-27 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 2020-08-17 00:00:00 | 2020-08-24 00:00:00 | 2020-08-31 00:00:00 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00 | 2020-09-28 00:00:00 | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00 | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00 | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 | 2021-01-18 00:00:00 | 2021-01-25 00:00:00 | 2021-02-01 00:00:00 | 2021-02-08 00:00:00 | 2021-02-15 00:00:00 | 2021-02-22 00:00:00 | 2021-03-01 00:00:00 | 2021-03-08 00:00:00 | 2021-03-15 00:00:00 | 2021-03-22 00:00:00 | 2021-03-29 00:00:00 | 2021-04-05 00:00:00 | 2021-04-12 00:00:00 | 2021-04-19 00:00:00 | 2021-04-26 00:00:00 | 2021-05-03 00:00:00 | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | 2021-05-24 00:00:00 | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-21 00:00:00 | 2021-06-28 00:00:00 | 2021-07-05 00:00:00 | 2021-07-12 00:00:00 | 2021-07-19 00:00:00 | 2021-07-26 00:00:00 | 2021-08-02 00:00:00 | 2021-08-09 00:00:00 | 2021-08-16 00:00:00 | 2021-08-23 00:00:00 | 2021-08-30 00:00:00 | 2021-09-06 00:00:00 | 2021-09-13 00:00:00 | 2021-09-20 00:00:00 | 2021-09-27 00:00:00 | 2021-10-04 00:00:00 | 2021-10-11 00:00:00 | 2021-10-18 00:00:00 | 2021-10-25 00:00:00 | 2021-11-01 00:00:00
Employee 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1
Average Weekly Rate
Holiday W/C | 2020-03-09 00:00:00 | 2020-03-16 00:00:00 | 2020-03-23 00:00:00 | 2020-03-30 00:00:00 | 2020-04-06 00:00:00 | 2020-04-13 00:00:00 | 2020-04-20 00:00:00 | 2020-04-27 00:00:00 | 2020-05-04 00:00:00 | 2020-05-11 00:00:00 | 2020-05-18 00:00:00 | 2020-05-25 00:00:00 | 2020-06-01 00:00:00 | 2020-06-08 00:00:00 | 2020-06-15 00:00:00 | 2020-06-22 00:00:00 | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-13 00:00:00 | 2020-07-20 00:00:00 | 2020-07-27 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 2020-08-17 00:00:00 | 2020-08-24 00:00:00 | 2020-08-31 00:00:00 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00 | 2020-09-28 00:00:00 | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00 | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00 | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 | 2021-01-18 00:00:00 | 2021-01-25 00:00:00 | 2021-02-01 00:00:00 | 2021-02-08 00:00:00 | 2021-02-15 00:00:00 | 2021-02-22 00:00:00 | 2021-03-01 00:00:00 | 2021-03-08 00:00:00 | 2021-03-15 00:00:00 | 2021-03-22 00:00:00 | 2021-03-29 00:00:00 | 2021-04-05 00:00:00 | 2021-04-12 00:00:00 | 2021-04-19 00:00:00 | 2021-04-26 00:00:00 | 2021-05-03 00:00:00 | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | 2021-05-24 00:00:00 | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-21 00:00:00 | 2021-06-28 00:00:00 | 2021-07-05 00:00:00 | 2021-07-12 00:00:00 | 2021-07-19 00:00:00 | 2021-07-26 00:00:00 | 2021-08-02 00:00:00 | 2021-08-09 00:00:00 | 2021-08-16 00:00:00 | 2021-08-23 00:00:00 | 2021-08-30 00:00:00 | 2021-09-06 00:00:00 | 2021-09-13 00:00:00 | 2021-09-20 00:00:00 | 2021-09-27 00:00:00 | 2021-10-04 00:00:00 | 2021-10-11 00:00:00 | 2021-10-18 00:00:00 | 2021-10-25 00:00:00 | 2021-11-01 00:00:00
Employee 1