change the date after a specific number of rows

[djbubu99]

I didn't managed to find a elegant solution to this...

basically i need to enter a date in the first 35 rows (ex: TODAY()), in the next 35 rows I need to enter TODAY()+1 and so on..


my solution was:

=IF(ROW()<=35,
TODAY(),
IF(ROW()<=35*2,
TODAY()+1)) ...

is there something smoother than this?

 

[poolhall]

try this: =TODAY()+INT((ROW()-1)/35)

 

[T. Valko]

I didn't managed to find a elegant solution to this...

basically i need to enter a date in the first 35 rows (ex: TODAY()), in the next 35 rows I need to enter TODAY()+1 and so on..


my solution was:

=IF(ROW()<=35,
TODAY(),
IF(ROW()<=35*2,
TODAY()+1)) ...

is there something smoother than this?

Here's another one...

Let's assume you want the dates listed starting in cell A1 then down the column.

Entered in A1 and copied down as needed:

=TODAY()+CEILING(ROWS(A$1:A1)/35,1)-1

 

[djbubu99]

Thanks!

Both solutions work :D

 

[djbubu99]

a combination of the solutions offered

=TODAY()+CEILING((ROW()-1)/35,1)-1

 

[T. Valko]

Thanks!

Both solutions work :D

You're welcome. Thanks for the feedback!