I want to fill dates across a row on Excel for every Friday of the week; e.g. 2/17/23, 2/24/23, etc.
Why does the fill handle for this series only work going down a column and not across a row? How can I get it to fill in this pattern across instead of down?