Ask Your Question

Creating a date column with 2 weeks added to each previous date cell [closed]

asked 2016-03-07 20:56:32 +0200

Elysium1982 gravatar image

I'd like to create a column in the easiest and fastest way possible. Typing a specific date and adding 2 weeks to each cell..for example, Cell1: 07/03/2016 Cell2: 21/03/2016 Cell3: 04/04/2016 and so on.

How can I do that? Cheers

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2016-11-17 22:47:13.470842

3 Answers

Sort by » oldest newest most voted

answered 2016-03-07 21:35:47 +0200

paul1149 gravatar image

updated 2016-03-08 02:12:46 +0200

Format the column for Date.

Enter the first date in a cell.

Select the cells you want to auto-fill, including the first cell.

Go Sheet (in v5.1) / Fill Cells / Series. Select Date, Day, and increment by 14

edit flag offensive delete link more


Incidentally: in v 5.1 "Fill Cells" moved from the Edit Menu (in v 5.0) to the Sheet Menu.

Rugslug gravatar imageRugslug ( 2016-03-08 00:17:11 +0200 )edit

Rugslug - thank you. I will correct "Select" to Sheet, which is what I meant.

paul1149 gravatar imagepaul1149 ( 2016-03-08 02:12:08 +0200 )edit

answered 2016-03-07 23:04:38 +0200

Ratslinger gravatar image

If original date will change you can calculate the other dates using =SUM(A1,14) where A1 is the starting date location and 14 is the number of days to increment by.

edit flag offensive delete link more

answered 2016-03-08 00:13:36 +0200

Rugslug gravatar image

Two more ways:

Have your first two dates in the first two cells. Select them both. Then left click on the little black square in the bottom right of the bottom cell. Drag it down as necessary. It will increment based on the difference between the two cells.

Cell A1 is your date. in cell A2, use the formula:


Then copy/drag it down as required.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-03-07 20:56:32 +0200

Seen: 2,986 times

Last updated: Mar 08 '16