Sum values across multiple months & years based on start and end dates

[wardfxj1]

Hi there
I'm really struggling to find the correct combo of formula to answer the following:

I have start and end dates of projects, Total annual values (2018-2020) and depending on when the project starts and ends profile the value across the months of the project ( some projects last multiple years)

Example below (although note example doesn't show all of the months to profile)

2018

2019

2020

2021

Jan-18

Feb-18

Mar-18

Apr-18

May-18

Jun-18

Start

End

Value

Value

Value

Value

5/03/2018

10/06/2020

$ 100,000.00

$ 180,000.00

$ 295,000.00

$ -

<colgroup><col><col><col span="3"><col><col><col span="6"></colgroup><tbody>
</tbody>

<colgroup><col><col><col span="3"><col><col><col span="4"></colgroup><tbody>
</tbody>

Thank you very much

Hope someone can help

 

[Sahitya]

I have worked on the formula and formulated in excel. please let me know how to place the excel