Forum Discussion
Help to generate a simple table
Hi all I am looking for some assistance please. My team will manually input a start date and a duration. This will show an end date. Simple enough! What i would then like is a table create ext...
Let's say Start Date is in B1 and Duration in B2.
In another cell, enter the following formula if you want the dates in a column:
=EDATE(B1, SEQUENCE(B2, , 0))
If you want the dates in a row:
=EDATE(B1, SEQUENCE(, B2, 0))
The result will spill to as many cells as needed. Format them as dates.