I am trying to make a column show the same date 3 times and then the next date 3 times. 5-5-175-5-175-5-175-6-175-6-175-6-17 and so on. I tried the plus dragging and it just repeated. I even went to 5-8 and stil the same. thanks for your help

Hi In cell A1 is the initial date (5-5-17). This formula in C1 and copy down:=$A$1+QUOTIENT(ROWS(C$1:C1)-1,3)

Forum Discussion

Copper Contributor

Apr 01, 2017

I am trying to make a column show the same date 3 times and then the next date 3 times.

5-5-17

5-5-17
5-6-17

5-6-17

and so on. I tried the plus dragging and it just repeated. I even went to 5-8 and stil the same. thanks for your help