Forum Discussion
Fill dates series of Thursdays, Fridays and Saturdays with fill handle
I don't know if that ever worked but there are a few options. As you mentioned you could create a formula but alternatively you could use 12/13, 12/14, 12/15 and 4 blank rows then drag down and that should give you the 3 days of interest separated by 4 blanks all the way down. Then while that column is still highlighted select 'Remove Duplicates' to get rid of all the blanks (except 1 which you can manually delete).
Unfortunately, that just gave me 12/15, 12/16, 12/17, then four blank rows, then 12/18, 12/19, 12/20 then four blank rows....etc., regardless of whether I just drug the handle or right drug and chose fill series. I got around it by using a column with two Fridays, one with two Saturdays, then two Sundays, filled that series to where I wanted it to stop, then cut and pasted everything into the bottom of the column and sorted by date, but what a pain. I'm just sure this used to work. But thanks for the reply.