Drag down - 5 rows same date and then plus 1 day

Contributor

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 there an easy way?

3 Replies

@Celia9 The easy way, though not very elegant, would be to start with something like this (dates in B, formulas used in C):

Riny_van_Eekelen_0-1658825090379.png

Now select B7:B11 and pull the drag handle down as far as needed to end up with this:

Riny_van_Eekelen_2-1658825285505.png

 

@Celia9 

=TODAY()+QUOTIENT(ROW(),5)

You can try this formula which i've entered in cell C5 in the example.

5 rows.JPG 

@Celia9 

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.