Excel for HR - Prorate Employee Salary for Merit Increase or Bonus Calculation

[@nhungbui1832]

Hi Rachel, I think we also should add "+1" in each formula days() for the best result of proration %, pls advise if I am incorrect? Thank you for your videos.

[@supa.scoopa]

Yes :)

[@geetuahuja6367]

Hi thank you for great video's . I am your new fan. I wanted to learn how to show project for next 2 -3 year for cost optimization graphs in Salary . Could you please help . With this we can to work how many years we wanted to keep almost same salary as per market max

[@mariabarreto7152]

Hi I need help in prorating a monthly inv at $5K max hours per month 20 prorated from 10/22 - 10/31- My numbers don't add up to my manager's totals

[@user-ug3zq3pz7w]

very helpful

[@violetweiss8784]

I used the days function and it gave me a -2.19%

[@sully199]

Great video

[@emilywong4890]

Thats not working if there are over 1000 staff in the company. Excel formular is suppose to simplify all the procedures, but not revising every formula manually.

[@charlesgist7592]

True, but hopefully you would not have a scenario where all 1,000 people started during the year or were unpaid for a portion of the year.

[@ToonTitans-123-u6x]

Better to create another column for unpaid days and add a condition in the days calculating formula by using the if function with the reference check for unpaid days. This way you don't have to manually enter the formula for all such cases. You can also add a column to determine rehires during a year and then use the IF function to calculate the days.

[@nhungbui1832]

@@ToonTitans-123-u6x could you please share me how to do this. Much thanks!