Spreadsheet: 700914d1603400599-date-format-time
Sheet: Sheet1

 |  |  | Current date | 1 Week later |  |  | What I need is for todays date, as Excel updates, to reflect, in a s eparate cell, date 19/10/2020
 |  |  | 2020-10-23 00:00:00
 |  |  | 2020-10-24 00:00:00
 |  |  | 2020-10-25 00:00:00
 |  |  | 2020-10-26 00:00:00 |  |  | 2020-10-26 00:00:00 | Here cell to display 26/10/2020
 |  |  | 2020-10-27 00:00:00
 |  |  | 2020-10-28 00:00:00
 |  |  | 2020-10-29 00:00:00
 |  |  | 2020-10-30 00:00:00
 |  |  | 2020-10-31 00:00:00
 |  |  | 2020-11-01 00:00:00
 |  |  | 2020-11-02 00:00:00 |  |  | 2020-11-02 00:00:00 | Here cell to display 2/11/2020
 |  |  | 2020-11-03 00:00:00
 |  |  | 2020-11-04 00:00:00
 |  |  | 2020-11-05 00:00:00
 |  |  | 2020-11-06 00:00:00
 |  |  | 2020-11-07 00:00:00
 |  |  | 2020-11-08 00:00:00
 |  |  | 2020-11-09 00:00:00 |  |  | Etc.
 |  |  | 2020-11-10 00:00:00
 |  |  | 2020-11-11 00:00:00
 |  |  | 2020-11-12 00:00:00
 |  |  | 2020-11-13 00:00:00
 |  |  | 2020-11-14 00:00:00
 |  |  | 2020-11-15 00:00:00
 |  |  | 2020-11-16 00:00:00
 |  |  | 2020-11-17 00:00:00
 |  |  | 2020-11-18 00:00:00
 |  |  | 2020-11-19 00:00:00
 |  |  | 2020-11-20 00:00:00
 |  |  | 2020-11-21 00:00:00
 |  |  | 2020-11-22 00:00:00
 |  |  | 2020-11-23 00:00:00
 |  |  | 2020-11-24 00:00:00
 |  |  | 2020-11-25 00:00:00
 |  |  | 2020-11-26 00:00:00
 |  |  | 2020-11-27 00:00:00
 |  |  | 2020-11-28 00:00:00
 |  |  | 2020-11-29 00:00:00
 |  |  | 2020-11-30 00:00:00
 |  |  | 2020-12-01 00:00:00
 |  |  | 2020-12-02 00:00:00
 |  |  | 2020-12-03 00:00:00
 |  |  | 2020-12-04 00:00:00
 |  |  | 2020-12-05 00:00:00
 |  |  | 2020-12-06 00:00:00
 |  |  | 2020-12-07 00:00:00
 |  |  | 2020-12-08 00:00:00
 |  |  | 2020-12-09 00:00:00
 |  |  | 2020-12-10 00:00:00
 |  |  | 2020-12-11 00:00:00
 |  |  | 2020-12-12 00:00:00
 |  |  | 2020-12-13 00:00:00
 |  |  | 2020-12-14 00:00:00
 |  |  | 2020-12-15 00:00:00
 |  |  | 2020-12-16 00:00:00
 |  |  | 2020-12-17 00:00:00
 |  |  | 2020-12-18 00:00:00
 |  |  | 2020-12-19 00:00:00
 |  |  | 2020-12-20 00:00:00
 |  |  | 2020-12-21 00:00:00
 |  |  | 2020-12-22 00:00:00
 |  |  | 2020-12-23 00:00:00
 |  |  | 2020-12-24 00:00:00
 |  |  | 2020-12-25 00:00:00
 |  |  | 2020-12-26 00:00:00
 |  |  | 2020-12-27 00:00:00
 |  |  | 2020-12-28 00:00:00
 |  |  | 2020-12-29 00:00:00
 |  |  | 2020-12-30 00:00:00
 |  |  | 2020-12-31 00:00:00
 |  |  | 2021-01-01 00:00:00
 |  |  | 2021-01-02 00:00:00
 |  |  | 2021-01-03 00:00:00
 |  |  | 2021-01-04 00:00:00
 |  |  | 2021-01-05 00:00:00
 |  |  | 2021-01-06 00:00:00
 |  |  | 2021-01-07 00:00:00
 |  |  | 2021-01-08 00:00:00
 |  |  | 2021-01-09 00:00:00
 |  |  | 2021-01-10 00:00:00
 |  |  | 2021-01-11 00:00:00
 |  |  | 2021-01-12 00:00:00
 |  |  | 2021-01-13 00:00:00
 |  |  | 2021-01-14 00:00:00
 |  |  | 2021-01-15 00:00:00
 |  |  | 2021-01-16 00:00:00
 |  |  | 2021-01-17 00:00:00
 |  |  | 2021-01-18 00:00:00
 |  |  | 2021-01-19 00:00:00
 |  |  | 2021-01-20 00:00:00
 |  |  | 2021-01-21 00:00:00
 |  |  | 2021-01-22 00:00:00
 |  |  | 2021-01-23 00:00:00
 |  |  | 2021-01-24 00:00:00
 |  |  | 2021-01-25 00:00:00
 |  |  | 2021-01-26 00:00:00
 |  |  | 2021-01-27 00:00:00
 |  |  | 2021-01-28 00:00:00
 |  |  | 2021-01-29 00:00:00
 |  |  | 2021-01-30 00:00:00
 |  |  | 2021-01-31 00:00:00