Hi Leah,
I was understood for prorating in June as hire date for him . But I don’t know his salary per month .
Example : He has Base Salary Per Month = 20,000.00 He hire date is 6 June 2016
Formula to calculate is 20,000.00*25/30=16,666.67 (Base Salary*Accual day/No. days of month)
But In this case, I don’t know his Base Salary Per month. I know Annual Salary only.
In the Normally. I will find Base salary per month to calculate to Annual Salary/12= Salary per month
Example : 240,000.00/12Month= 20,000 Per month
But In detail data, It has a start date of Annual Salary is 6 June 2016. I don’t know amount of your data, It prorates as Hire date or It’s max to this year