Spreadsheet: 705703d1606264357-update-all-dates-to-the-year-that-is-entered-in-a-cell-update-year
Sheet: Sheet1

 | I would like to have it so all the dates automatically update and change their current year to whatever year I have entered in cell V1. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00
 | 2020-01-01 00:00:00 |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  | 2020-01-01 00:00:00
 | 2020-02-01 00:00:00 |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  | 2020-02-01 00:00:00
 | 2020-03-01 00:00:00 |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  | 2020-03-01 00:00:00
 | 2020-04-01 00:00:00 |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  | 2020-04-01 00:00:00
 | 2020-05-01 00:00:00 |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  | 2020-05-01 00:00:00
 | 2020-06-01 00:00:00 |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  | 2020-06-01 00:00:00
 | 2020-07-01 00:00:00 |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  | 2020-07-01 00:00:00
 | 2020-08-01 00:00:00 |  |  |  |  | 2020-08-01 00:00:00 |  |  |  |  | 2020-08-01 00:00:00 |  |  |  |  | 2020-08-01 00:00:00
 | 2020-09-01 00:00:00 |  |  |  |  | 2020-09-01 00:00:00 |  |  |  |  | 2020-09-01 00:00:00 |  |  |  |  | 2020-09-01 00:00:00
 | 2020-10-01 00:00:00 |  |  |  |  | 2020-10-01 00:00:00 |  |  |  |  | 2020-10-01 00:00:00 |  |  |  |  | 2020-10-01 00:00:00
 | 2020-11-01 00:00:00 |  |  |  |  | 2020-11-01 00:00:00 |  |  |  |  | 2020-11-01 00:00:00 |  |  |  |  | 2020-11-01 00:00:00
 | 2020-12-01 00:00:00 |  |  |  |  | 2020-12-01 00:00:00 |  |  |  |  | 2020-12-01 00:00:00 |  |  |  |  | 2020-12-01 00:00:00
 | 2020-01-01 00:00:00 |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  | 2020-01-01 00:00:00
 | 2020-02-01 00:00:00 |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  | 2020-02-01 00:00:00
 | 2020-03-01 00:00:00 |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  | 2020-03-01 00:00:00
 | 2020-04-01 00:00:00 |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  | 2020-04-01 00:00:00
 | 2020-05-01 00:00:00 |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  | 2020-05-01 00:00:00
 | 2020-06-01 00:00:00 |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  | 2020-06-01 00:00:00
 | 2020-07-01 00:00:00 |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  | 2020-07-01 00:00:00
 | 2020-08-01 00:00:00 |  |  |  |  | 2020-08-01 00:00:00 |  |  |  |  | 2020-08-01 00:00:00 |  |  |  |  | 2020-08-01 00:00:00
 | 2020-09-01 00:00:00 |  |  |  |  | 2020-09-01 00:00:00 |  |  |  |  | 2020-09-01 00:00:00 |  |  |  |  | 2020-09-01 00:00:00
 | 2020-10-01 00:00:00 |  |  |  |  | 2020-10-01 00:00:00 |  |  |  |  | 2020-10-01 00:00:00 |  |  |  |  | 2020-10-01 00:00:00
 | 2020-11-01 00:00:00 |  |  |  |  | 2020-11-01 00:00:00 |  |  |  |  | 2020-11-01 00:00:00 |  |  |  |  | 2020-11-01 00:00:00
 | 2020-12-01 00:00:00 |  |  |  |  | 2020-12-01 00:00:00 |  |  |  |  | 2020-12-01 00:00:00 |  |  |  |  | 2020-12-01 00:00:00