I want to use Excel to fill a range of dates, the first and 15th of each month to be precise.
My spreadsheet currently looks like so:
When I drag down, it looks like so:
Instead of continuing the pattern, it just repeats what's there. I have tried each of the following AutoFill options to no avail:
- Copy Cells
- Fill Series
- Fill Formatting Only
- Fill Without Formatting
- Fill Days
- Fill Weekdays
- Fill Months
- Fill Years
What am I doing wrong?
Thanks
Best Answer
I was able to write a Excel Macro to accomplish this:
I actually used this to see to correct formatting, note the single quote. But this changes the entry from a date to a string.