Dates not dates when using Excel 2010 Table Feature

Stubby

Board Regular
Joined
Mar 5, 2002
Messages
186
Hi All

I have a table that has a number of columns with dates that increase on a weekly basis. Every quarter I need to change the dates for the next quarter however when I use the fill handle to drag the first couple of dates all I get is excel increasing the last digit by one. I have checked the cell an it is formatted as a date. Is this a bug in excel or by "Microsoft Design" and is there a work around? Incidentally the process works fine when the data is NOT in a table!!

Any help or guidance would be much appreciated as it is a little frustrating!

Stubby
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,108,924
Messages
5,525,654
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top