Copy Dates Horizontally

[kumara_faith]

Hi,
I have entered the following in A1:

4/4/11

I want to drag this horizontally to be 4/5/11, 4/6/11 and so on. But when I drag it horizontally, it becomes 4/4/12, 4/4/13 and so on.

How do do this correctly ?

Appreciate help.

 

[MrKowz]

Instead of dragging with the left click, drag it with the right click, and then choose "Fill Weekdays"

 

[kumara_faith]

Hi,

I am using Excel 2007's table and therefore I do not have that option.If I do not use Excel's table, then I will have the option.

How do do this with Excel's table ?

Excel Workbook
	B	C	D	E	F	G	H	I
2	Column1	4/5/2011	4/5/2012	4/5/2013	4/5/2014	Column7	Column8	Column9
Schedule

 

[dannac]

in d1 ..... =c1+1

copied across

 

[snoopyhr]

post error, sorry