Hi all,
i would need your help.
I am searching for a formula to calculate the year to go amounts.
I do have several person working in the company, some stays the whole year, some others joins during the year till the end of the year and some others leave before the end of the year. How to calculate the remaining salary till the end of the year for the different cases?
Does anybody have an idea?
Many thanks
i would need your help.
I am searching for a formula to calculate the year to go amounts.
I do have several person working in the company, some stays the whole year, some others joins during the year till the end of the year and some others leave before the end of the year. How to calculate the remaining salary till the end of the year for the different cases?
Does anybody have an idea?
Many thanks
Name | Start month | End month | Salary | Year to go 5-12 | Year to go 6-12 | Year to go 7-12 | Year to go 8-12 | Year to go 9-12 | Year to go 10-12 | Year to go 11-12 | Year to go 12-12 |
John | 1 | 12 | 1000 | 8000 | 7000 | 6000 | 5000 | 4000 | 3000 | 2000 | 1000 |
Kelly | 1 | 1 | 2000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Kim | 2 | 6 | 1500 | 3000 | 1500 | ||||||
Andy | 3 | 12 | 1000 | 8000 | 7000 | 6000 | 5000 | 4000 | 3000 | 2000 | 1000 |
Susan | 9 | 12 | 2000 | 0 | 0 | 0 | 0 | 8000 | 6000 | 4000 | 2000 |