Dear Team,
New to the Platform so I hope I am doing this the right way.
I want to create an excel sheet which is able to calculate the Monthly Salaries of employees based on their entry(start) dates and also if the said employee was on Unpaid Leave or not.
FOr example in the attached sheet, Granny Bear who started in January 15th, was on Unpaid leave from March to end of May which means the company will not have to pay her for March, April and May.
How can I create a formula that is able to calculate the monthly salary simply based on the data in this table and the conditions explained above?
Same goes for the Headcount, I want to create a formula that returns a 1 for each month the employee was fully working.
Will really appreciate any ideas on this.
Many thanks!
KB
Bookmarks