Excel salary bonus sheet
Budget: $10 – $30 USD
We need to process a bonus for several employees.
The bonus is calculated based on the basic salary of an employee, how many days they worked in the year (specific date and then a percentage will be given.
For example:
Salary 1000
Date 01/01/2022 till 31/10/2022 total (10 months)
Percentage given 60%
1000 * 10 * 60 / 100 = 6000
I want the formula to be specific with days (date).
The bonus is calculated based on the basic salary of an employee, how many days they worked in the year (specific date and then a percentage will be given.
For example:
Salary 1000
Date 01/01/2022 till 31/10/2022 total (10 months)
Percentage given 60%
1000 * 10 * 60 / 100 = 6000
I want the formula to be specific with days (date).