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...
With Start Date in B1, Duration in B2 and Total Amount in B3, enter the following formula in another cell:
=EDATE(B1, SEQUENCE(, B2, 0))
And in the cell below it:
=IF(SEQUENCE(, B2), B3/B2)
You can even combine them in one formula:
=VSTACK(EDATE(B1, SEQUENCE(, B2, 0)), IF(SEQUENCE(, B2), B3/B2))
This is perfect! Thank you.