Hello Everyone. I wonder if someone can help me formula with a formula to calculate the year to date budget with a variable length of contract please
The financial year starts from 01 of April and ends on 31st of March. It should look like below. Any help will be really appreciated
<colgroup><col width="64" style="width: 48pt;">
<col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;">
<col width="144" style="width: 108pt; mso-width-source: userset; mso-width-alt: 5266;">
<col width="151" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5522;">
<col width="64" style="width: 48pt;" span="2">
<col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;" span="2">
<col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;">
<col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;">
<col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;">
<col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;" span="3">
<tbody>
</tbody>
The financial year starts from 01 of April and ends on 31st of March. It should look like below. Any help will be really appreciated
financial year start | 01/04/2018 | fin year | 16/17 | 17/18 | 18/19 | 19/20 | 20/21 | ||||||
end date of current period | 31/08/2018 | start | 01/04/2016 | 01/04/2017 | 01/04/2018 | 01/04/2019 | 01/04/2020 | ||||||
Current Month | 5 | end | 31/03/2017 | 31/03/2018 | 31/03/2019 | 31/03/2020 | 31/03/2021 | ||||||
Call_Off_Contract_Number | Contrcat name | ContractMonthStart | ContractMonthEnd | MonthsInContract | Extension? | ContractValue | MonthlyValue | ||||||
1 | A | 01/06/2016 | 01/05/2018 | 24 | (blank) | £896,591.85 | £37,357.99 | 373,579.94 | 448,295.93 | 74,715.99 | |||
2 | B | 01/08/2016 | 01/07/2018 | 24 | (blank) | £557,372.48 | £23,223.85 | ||||||
3 | C | 01/08/2016 | 01/07/2019 | 36 | Y | £666,362.68 | £18,510.07 | ||||||
4 | D | 01/08/2016 | 01/07/2018 | 24 | (blank) | £425,053.00 | £17,710.54 | ||||||
5 | E | 01/08/2016 | 01/07/2018 | 24 | (blank) | £1,484,640.00 | £61,860.00 | ||||||
6 | F | 01/08/2016 | 01/07/2018 | 24 | (blank) | £342,809.60 | £14,283.73 | ||||||
7 | G | 01/08/2016 | 01/07/2018 | 24 | (blank) | £565,735.05 | £23,572.29 |