I'm trying to calculate the cost over a period of time where the start and end are provided in two cells (e.g. F4 is the start date and G4 is the end date).
Sometimes the period between these two cells spans multiple financial years.
In another table I have hourly rates based on the financial year. The table also shows the total annual rate.
If the 2023-24 rate for the selected person is $64.16 (Q4), 2024-25 rate is $65.76 (S4) and 2025-26 is $67.40 (U4) and the date in F4 is 20-03-2023 and F5 is 16-03-2026, I need to factor in the hourly increase over the period defined in F4 and F5. The Resource Allocation table will also have the number of days and the number of hours. The only other variable is the name of the resource (column C). The name is in both the table where this calculation is to occur (L4) and the Resources and Annual Salary table with the hourly and annual rates.
Sample.xlsx
Is this even possible? If so, I would greatly appreciate anyone's help!
Cheers
Glen
Bookmarks