Stubby
Board Regular
- Joined
- Mar 5, 2002
- Messages
- 188
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
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