Forum Discussion
setting number of rows?
Hello everyone, so I'm working with excel to make tables of schedule for Tourism company. I was wondering if it possible to set number of rows based on dates. so for example: if the tour is 7 ...
It would be difficult to create a row with merged cells at the bottom (it would require VBA code, which is probably overkill). But the dates can be generated by a formula:
Let's say you enter the start date in J1 and the number of dates in J2.
Format A4:A50 (or however far down you want) as a date.
In A4, enter the formula
=SEQUENCE(J2,,J1)
It will spill to as many cells down as needed.
- WOW. Great! that is very helpful!
Thank you soo much!
