The "To Keep Up" Wiki

A collection of information we find useful

User Tools

Site Tools

Trace:
libreoffice_annoyances

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
libreoffice_annoyances [2021.11.22 08:34] – Steve Isenberglibreoffice_annoyances [2021.11.22 08:34] – [Replace dates with incremented year] Steve Isenberg
Line 6: Line 6:
 Your spreadsheet has a column with dates, say B7 has 1/2/2019 and you want to replace the dates in the rest of the column with the next year, e.g., 2020.   Your spreadsheet has a column with dates, say B7 has 1/2/2019 and you want to replace the dates in the rest of the column with the next year, e.g., 2020.  
   - Insert new column to right of dates column (new and blank column C)   - Insert new column to right of dates column (new and blank column C)
-  - Apply this formula in new column C next to the first date you want to change.  Say column B row 7 has 1/2/2019.  Put this formula in column C row 7: <code>=DATE(year(B7)+1,month(B7),day)B7))</code>+  - Apply this formula in new column C next to the first date you want to change.  Say column B row 7 has 1/2/2019.  Put this formula in column C row 7: <code>=DATE(year(B7)+1,month(B7),day(B7))</code>
   - Select the cell C7 and drag down to select all rows in column C that you want to replace column B's dates   - Select the cell C7 and drag down to select all rows in column C that you want to replace column B's dates
   - Control-D (pastes the formula down the column). You should see the updated dates in column C.    - Control-D (pastes the formula down the column). You should see the updated dates in column C. 
libreoffice_annoyances.txt · Last modified: 2022.12.05 13:05 by Steve Isenberg