Amit Punia
Member
In the attached file, there are targets to be achieved by employees designation wise i.e. Executive, Senior Executive & Assistant Manager. Firstly we have to calculate the month zero based on the date of joining of the employee. If the employees joins before 21st of the month then the month zero is the same month. Eg. If the DOJ is 12th October 2016 then the Month Zero is October. If the DOJ is after 21st of the month then the Month Zero (M0) is subsequent month i.e. November.
After calculating the M0, we have to calculate the target based on the designation of the employee. Target amount and percentages are mentioned in the sheet. Target amount should start from Month One (M1) based on the target percentage and designation.
For the attached file, I can calculate everything manually, however if I add additional employees every month in the sheet then I've to calculate the same again and again.
Kindly share any formula which can fulfill the above need.
After calculating the M0, we have to calculate the target based on the designation of the employee. Target amount and percentages are mentioned in the sheet. Target amount should start from Month One (M1) based on the target percentage and designation.
For the attached file, I can calculate everything manually, however if I add additional employees every month in the sheet then I've to calculate the same again and again.
Kindly share any formula which can fulfill the above need.
