Spreadsheet: 482454d1475070099-help-with-a-date-formula-to-copy-a-w-c-date-week-commencing
Sheet: Dates

Monday | 2016-10-03 00:00:00 | w/c 3rd October
Tuesday | 2016-10-04 00:00:00 | w/c 3rd October
Wednesday | 2016-10-05 00:00:00 | w/c 3rd October
Thursday | 2016-10-06 00:00:00 | w/c 3rd October
Friday | 2016-10-07 00:00:00 | w/c 3rd October
Saturday | 2016-10-08 00:00:00 | w/c 3rd October
Sunday | 2016-10-09 00:00:00 | w/c 3rd October
Monday | 2016-10-10 00:00:00 | w/c 10th October
Tuesday | 2016-10-11 00:00:00 | w/c 10th October
Wednesday | 2016-10-12 00:00:00 | w/c 10th October
Thursday | 2016-10-13 00:00:00 | w/c 10th October
Friday | 2016-10-14 00:00:00 | w/c 10th October
Saturday | 2016-10-15 00:00:00 | w/c 10th October
Sunday | 2016-10-16 00:00:00 | w/c 10th October
Monday | 2016-10-17 00:00:00 | w/c 17th October
Tuesday | 2016-10-18 00:00:00 | w/c 17th October
Wednesday | 2016-10-19 00:00:00 | w/c 17th October
Thursday | 2016-10-20 00:00:00 | w/c 17th October
Friday | 2016-10-21 00:00:00 | w/c 17th October
Saturday | 2016-10-22 00:00:00 | w/c 17th October
Sunday | 2016-10-23 00:00:00 | w/c 17th October
Monday | 2016-10-24 00:00:00
Tuesday | 2016-10-25 00:00:00
Wednesday | 2016-10-26 00:00:00
Thursday | 2016-10-27 00:00:00
Friday | 2016-10-28 00:00:00
Saturday | 2016-10-29 00:00:00
Sunday | 2016-10-30 00:00:00
Monday | 2016-10-31 00:00:00
Tuesday | 2016-11-01 00:00:00
Wednesday | 2016-11-02 00:00:00
Thursday | 2016-11-03 00:00:00
Friday | 2016-11-04 00:00:00
Saturday | 2016-11-05 00:00:00
Sunday | 2016-11-06 00:00:00
Monday | 2016-11-07 00:00:00
Tuesday | 2016-11-08 00:00:00
Wednesday | 2016-11-09 00:00:00
Thursday | 2016-11-10 00:00:00
Friday | 2016-11-11 00:00:00
Saturday | 2016-11-12 00:00:00
Sunday | 2016-11-13 00:00:00
Monday | 2016-11-14 00:00:00
Tuesday | 2016-11-15 00:00:00
Wednesday | 2016-11-16 00:00:00
Thursday | 2016-11-17 00:00:00
Friday | 2016-11-18 00:00:00
Saturday | 2016-11-19 00:00:00
Sunday | 2016-11-20 00:00:00
Monday | 2016-11-21 00:00:00
Tuesday | 2016-11-22 00:00:00
Wednesday | 2016-11-23 00:00:00
Thursday | 2016-11-24 00:00:00
Friday | 2016-11-25 00:00:00
Saturday | 2016-11-26 00:00:00
Sunday | 2016-11-27 00:00:00
Monday | 2016-11-28 00:00:00
Tuesday | 2016-11-29 00:00:00
Wednesday | 2016-11-30 00:00:00
Thursday | 2016-12-01 00:00:00
Friday | 2016-12-02 00:00:00
Saturday | 2016-12-03 00:00:00
Sunday | 2016-12-04 00:00:00
Monday | 2016-12-05 00:00:00
Tuesday | 2016-12-06 00:00:00
Wednesday | 2016-12-07 00:00:00
Thursday | 2016-12-08 00:00:00
Friday | 2016-12-09 00:00:00
Saturday | 2016-12-10 00:00:00
Sunday | 2016-12-11 00:00:00
Monday | 2016-12-12 00:00:00
Tuesday | 2016-12-13 00:00:00
Wednesday | 2016-12-14 00:00:00
Thursday | 2016-12-15 00:00:00
Friday | 2016-12-16 00:00:00
Saturday | 2016-12-17 00:00:00
Sunday | 2016-12-18 00:00:00
Monday | 2016-12-19 00:00:00
Tuesday | 2016-12-20 00:00:00
Wednesday | 2016-12-21 00:00:00
Thursday | 2016-12-22 00:00:00
Friday | 2016-12-23 00:00:00
Saturday | 2016-12-24 00:00:00
Sunday | 2016-12-25 00:00:00
Monday | 2016-12-26 00:00:00
Tuesday | 2016-12-27 00:00:00
Wednesday | 2016-12-28 00:00:00
Thursday | 2016-12-29 00:00:00
Friday | 2016-12-30 00:00:00
Saturday | 2016-12-31 00:00:00
Sunday | 2017-01-01 00:00:00
Monday | 2017-01-02 00:00:00
Tuesday | 2017-01-03 00:00:00