Hi Leah,
I was understood for prorate 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 calcurate 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 Annaul Salary only.
In the Normally. I will find Base salary per month to calcurate to Annual Salary/12= Salary per month
Example : 240,000.00/12Month= 20,000 Per month
But In detail data It has start date of Annual Salary is 6 June 2016. I don’t know amount in your data, It prorate as Hire date or It’s max to this year