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 -

=today()

=today()+1

=today()+2

=today()+3

<tbody>
</tbody>

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:

=today()

=today()+1

=today()+2

=today()+3

=today()+2

=today()+3

<tbody>
</tbody>

What I thought would happen:

=today()

=today()+1

=today()+2

=today()+3

=today()+4

=today()+5

<tbody>
</tbody>

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!