Can't work out how to drag fill formula series.

[caststone]

I have a spreadsheet where the headers in each column are increments of todays date as below -

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]=today()
[/TD]
[TD]=today()+1
[/TD]
[TD]=today()+2
[/TD]
[TD]=today()+3
[/TD]
[/TR]
</tbody>[/TABLE]

To extend this series across the worksheet I selected the last two cells and used the drag handle in the bottom right hand corner.

What actually happens:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]=today()
[/TD]
[TD]=today()+1
[/TD]
[TD]=today()+2
[/TD]
[TD]=today()+3
[/TD]
[TD]=today()+2
[/TD]
[TD]=today()+3
[/TD]
[/TR]
</tbody>[/TABLE]


What I thought would happen:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]=today()
[/TD]
[TD]=today()+1
[/TD]
[TD]=today()+2
[/TD]
[TD]=today()+3
[/TD]
[TD]=today()+4
[/TD]
[TD]=today()+5
[/TD]
[/TR]
</tbody>[/TABLE]



Does anyone please know why this isn't working or how I can easily extend the series?

Thank you

 

[FormR]

Hi, two possible options.

Option 1 - copy the C2 formula across.
Option 2 - copy the B3 formula across.

Excel 2013
	A	B	C	D	E	F
2	Option 1	07/12/2016	08/12/2016	09/12/2016	10/12/2016	11/12/2016
3	Option 2	07/12/2016	08/12/2016	09/12/2016	10/12/2016	11/12/2016
Sheet1

Cell Formulas
Range	Formula
B2	=TODAY()
B3	=TODAY()+COLUMNS($B3:B3)-1
C2	=B2+1

 

[caststone]

Oh my word - I feel silly now! That is such a simple solution. I went for option 2 and of course it worked perfectly.

Thank you very much for that!