Forum Discussion

SamF's avatar
SamF
Copper Contributor
Jan 09, 2025

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...
Charting
excel
SamF's avatar
SamF
Copper Contributor
Jan 10, 2025

This is perfect - Thank you so much

 

I now have a further query if you dont mind! So in another cell i will have a total Value. I would now like to split this value by the number of months relative to the dates.

 

So using the above - £120,000 is a total sum. 

 

I would like this to be divided by the duration months and it will appear below the months that have been created above.

 

That way i have a monthly cost table created.

 

Thank you

HansVogelaar's avatar
HansVogelaar
MVP
Jan 10, 2025

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))

  • SamF's avatar
    SamF
    Copper Contributor
    Jan 13, 2025

    This is perfect! Thank you.

Resources