increment the cells in pairs

[BDuterte2025]

I have an action file with a list of 5 actions to perform per day.
So I need a column with 5 on Monday then 5 on Tuesday then 5 on Wednesday and so on.

After putting 5 Mondays and 5 Tuesdays in the column I wanted to use the drop down menu to slide down to the bottom and get the rest of my week.

But the extension is not done correctly, I have a duplication of my previous cells and I end up with 5 Monday then 5 Tuesday then 5 Monday then 5 Tuesday and so on.

How to make excel understand that I want blocks of 5 each time and that it repeats until Sunday? (cf sheet 2 in the file)

Thanks in advance

[#2]

@BDuterte2025

It's not that much work to populate the list by hand, but see the attached version for a formula.

[#3]

@Hans Vogelaar 

Indeed, filling a week by hand does not require that much work.
I was hoping to learn a replicable method for other longer cases, like the list of days in a year from (01/01/22 to 12/31/22) each being duplicated 5 times for the number of daily tasks.
All in the same column of course.
Is there a way to apply your formula to the case of the days of the year ?
Even better if it only takes into account working days.
For example, column F with the days of the week in place 5 by 5.

[#4 · Accepted solution]

@BDuterte2025 

You could use

=DATE(2022,1,1)+QUOTIENT(ROW()-1,5)

for that.

[#5]

Thank you for the answer.
Everything is working as expected.
Good luck for the next case