Forum Discussion
Celia9
Jul 26, 2022Brass Contributor
Drag down - 5 rows same date and then plus 1 day
Hola 🙂 I would like to have an option to drag down (to create new rows in my table). The date column should repeat the same date 5 times, add one day, and repeat that date 5 times. Is th...
PeterBartholomew1
Jul 26, 2022Silver Contributor
I would use a formula, but that is simply the way I work
= StartDate + QUOTIENT(SEQUENCE(Count,,0),5)No 'miracles' with flash fill etc for me I'm afraid.