How to change the date below 2020 to 2019? Many bulk changes life does not change the date

CodePudding user response:

Use the formula to minus one year, such as the time you want to modify is A1, then modify the cell with the formula
=the DATE (YEAR (A1) - 1, the MONTH (A1), DAY (A1)

CodePudding user response:

If direct change, can be used to replace, 2020 to replace 2019

CodePudding user response:

refer to the second floor weixin_wuming response:

if direct change, can be used to replace, 2020 to replace 2019

Thank you, this way can try