Large dataset with varying Start and End Dates.
The Week Numbers need to fall in financial year (01/04/2023 - 31/03/2023).
01/04/2023 needs to be Week 1, 10/04/2023 is Week 2 and so forth with possible carry over into the new year.
Using the Start and End Date, allocate the weekly cost to the...