Forum Discussion
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...
Celia9 The easy way, though not very elegant, would be to start with something like this (dates in B, formulas used in C):
Now select B7:B11 and pull the drag handle down as far as needed to end up with this: