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