Ask Your Question

I would like to auto enter consecutive dates on every other row in one column [closed]

asked 2013-01-26 22:33:43 +0200

samspade gravatar image

Entering dates in Calc

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 23:48:30.473492

1 Answer

Sort by » oldest newest most voted

answered 2013-01-27 01:47:06 +0200

m.a.riosv gravatar image
  1. Drag the cell with date down.
  2. With a formula (If date is in A2):
    A3: =A2+1
    and drag or copy de formula down.
  3. Select the range to fill and use: Menu/Fill/Series, select Series data as Date and other options as you need.
edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-01-26 22:33:43 +0200

Seen: 4,598 times

Last updated: Jan 27 '13