Shortcut: advance the dates of multiple cells at once

I’d like to advance the dates in multiple cells by 1 day.

For example, I have 4 different cells, each a different date:
Nov 1
Nov 4
Nov 7
Dec 1

I want to quickly change them all to be:
Nov 2
Nov 5
Nov 7
Dec 2

Correct me if I’m wrong, but there isn’t a way to do this via options already available in Calc.

I figure this could be accomplished with a macro, but am having trouble setting it up.

Any help appreciated!

Your dates might be text, not numbers (dates are numbers), see How to convert number text to numeric data

If the Dates are actual dates then you could

  • Enter a 1 in a blank cell
  • Copy the cell
  • Select your 4 date cells and click Edit > Paste Special > Paste special.
  • In the dialogue that opens, under Operations, select Add, then press OK.

All the selected dates will have 1 day added to them


Perfect thanks!!

Also, you can select the dates range, and drag the fill handle to the right. You will need an empty column to the right (or copy the new dates, undo, and paste over the original dates).

1 Like