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)
<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
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>
Hope someone can help