Forum Discussion
dates in groups of 3
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-5-17 5-6-17 5-6-17 5-6-17 and so on. I tried the plus dragging and it just rep...
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)
This works fine.