Forum Discussion
Get Excel to fill a series of sequential dates
asdfasfqw3lge1237u8ey I suspect that you are using a structured Excel table. If so, that the header fields are texts even when the may look like dates. Dragging a text that ends with a number, down or across, will increment that last number for every cell.
Now, when you say that you are going to track expenses then it not a good idea to capture the date in different columns for every month. It is much better to build a table in a tabular form, for example [Date, Expense Type, Description, Amount] and then enter the expense items as the come in and use a pivot table to created reports/summaries by month, by expense type or whatever.
asdfasfqw3lge1237u8ey I suspect that you are using a structured Excel table. If so, that the header fields are texts even when the may look like dates. Dragging a text that ends with a number, down or across, will increment that last number for every cell.
Now, when you say that you are going to track expenses then it not a good idea to capture the date in different columns for every month. It is much better to build a table in a tabular form, for example [Date, Expense Type, Description, Amount] and then enter the expense items as the come in and use a pivot table to created reports/summaries by month, by expense type or whatever.
Riny_van_EekelenI think that was the cause. I fixed it by switching off the table (R-click, Table, Convert to Range), then re-typing the first date for the month. This new date cooperated with the auto-fill. Once each month had its columns renamed properly, I re-tabled them.
