The "To Keep Up" Wiki

Maybe not annoyances but ways of getting things done.

Your spreadsheet has a column with dates, say 1/2/2019 and you want to replace all of them with the next year, e.g., 1/2/2020.

1. Insert new column to right of dates column
2. Apply this formula in new column next to date you want to change. Say column B row 7 has 1/2/2019. Put this formula in column C row 7:

   =DATE(year(B7)+1,month(B7),day)B7))

3. Select the cell C7 and drag down to select all rows in column C that you want to replace column B's dates
4. Control-D (pastes the formula down the column)
5. Select all of the column C cells you have changed, and copy to clipboard
6. Put cursor in first date you want to change, that is, in cell B7
7. Edit > Paste Special > Paste Special. Make sure All is not checked and Formula is not checked. Paste. OK the overwrite.