For example: monthly salary of an employee A is $30,000
$35,000 effective from 2 Jan 2024
$40,000 effective from 15 Apr 2024
In data file, there are 2 rows for Employee A
Fiscal year is 1 Jan 2024 to 31 Dec 2024

Question: How to calculate the total salary in 2024?

I tried to use (days(end date, start date)+1)/366, however the salary is not accurate because what I need is ((30/31+2+14/30)*35000)+(16/30+8)*40000

Please advise, thanks