Forum Discussion

Cinbar's avatar
Cinbar
Copper Contributor
Dec 02, 2025

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...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 03, 2025

in A2:

=SCAN( DATE(2025,12,11), SEQUENCE(21),
  LAMBDA(date,n,
    LET(
      nextDate, IF( n = 1, date, date +1 ),
      IF( WEEKDAY( nextDate ) > 4, nextDate, nextDate +4 )
    )
  )
)

where DATE(2025,12,11) is your 1st Thursday and SEQUENCE(21) is the number of dates (21 here) you need to generate

Cinbar's avatar
Cinbar
Copper Contributor
Dec 03, 2025

Thank you for your reply. I haven't tried this, but I'm sure it will work. The problem is that I only need this for about a five-month span, so it was faster and easier to make a series for each of the three days, then cut, paste into a column and sort. I don't know when I might need to do this again. I'm just sure that this used to work, but it's something I don't have the need to do often, so I don't know when it might have stopped working. I remember because I used to teach an Excel class, and using the fill handle in various situations was something people always loved to learn and were amazed by, so that's why I feel so strongly it did work at one point.

Resources