I have a staff total salary data with staff Start Date and End Date spanning multiple years.
What I would like to achieve is to break down this total salary into individual years in multiple rows, then calculate the daily rate and apply the salary for each year accordingly.
As I have large data with more than 3000 staff and complex start and end dates, I wonder if this can be done in Query Editor? If so could someone please suggest a solution? I attach here the excel file for your reference. Salary Yearly Breakdown.xlsx (11.7 KB)
Thank you and much appreciated.