multiple replication

[deniztopcu]

Hello
The dates should repeat exactly after the red arrow sign.
please help.

 

[Micron]

Select the range of 5 dates, hold ctrl key down and drag to the right?

 

[Fluff]

How about

=INDEX($A$2:$E$2,MOD(COLUMNS($A2:A2)-1,5)+1)

 

[deniztopcu]

thanks but it's not what I want in two answers

 

[Fluff]

If that is not what you want, then what exactly do you want?

 

[deniztopcu]

If that is not what you want, then what exactly do you want?

thank you.
I don't know why it didn't work the first time I tried but
The solution you posted worked when I tried it now.

 

[Micron]

Looks to me like it works

 

[Fluff]

Glad we could help & thanks for the feedback.