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

caststone

New Member
Joined
Feb 3, 2015
Messages
17
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

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,220
Office Version
365
Platform
Windows
Hi, two possible options.

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

<b>Excel 2013</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Option 1</td><td style="text-align: right;background-color: #FFFF00;;">07/12/2016</td><td style="text-align: right;background-color: #FFFF00;;">08/12/2016</td><td style="text-align: right;;">09/12/2016</td><td style="text-align: right;;">10/12/2016</td><td style="text-align: right;;">11/12/2016</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Option 2</td><td style="text-align: right;background-color: #FFFF00;;">07/12/2016</td><td style="text-align: right;;">08/12/2016</td><td style="text-align: right;;">09/12/2016</td><td style="text-align: right;;">10/12/2016</td><td style="text-align: right;;">11/12/2016</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B2</th><td style="text-align:left">=TODAY(<font color="Blue"></font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B3</th><td style="text-align:left">=TODAY(<font color="Blue"></font>)+COLUMNS(<font color="Blue">$B3:B3</font>)-1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C2</th><td style="text-align:left">=B2+1</td></tr></tbody></table></td></tr></table><br />
 

caststone

New Member
Joined
Feb 3, 2015
Messages
17
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!
 

Forum statistics

Threads
1,082,569
Messages
5,366,360
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top