Forum Discussion
Fill dates series of Thursdays, Fridays and Saturdays with fill handle
I swear I remember this used to work. I've entered the following dates in Excel, which are consecutive Thursdays, Fridays and Saturdays. I've selected the six cells, and you used to could drag the fi...
You can achieve this by formula if you wish.
=LET(x,SEQUENCE(31,,DATE(2025,12,1)),FILTER(x,WEEKDAY(x)>=5))
Thank you for your reply. I'm just sure there used to be an easier way to do this. I may never do this again, so I just created a weekly series for three days, then cut and pasted them into one column and sorted.
