For each employee, I have:
Hire date
Termination date
Annual salary
I need to calculate how much the employee earned each month based on the number of working days in that month (and year).
I have attached an image of an example of how the setup is like. I need to blank column to be fill out with a formula that will calculate until the year 2030. As you can see we have termination dates in the middle of the year and start dates in the middle of the year so the annual salary will the hald the first year the employee starts. I need to show that in my workbook.
Salary Calculation Sample.xlsx
Bookmarks