Hi,
I am trying to work out probationary costs for my work.
For example, in the first month, if he leaves, he will get 0. However if he leaves between 1 month and 6 months, he will get 1 week pay. and anything between 6 months and 4 years he will get 4 weeks pay. Finally after the 4 years, every incremental year worked gains 1 week of payment if he leaves. so if he works for 5 years we pay him for 5 weeks after leaving date, 6years for 6 weeks and so on up until 12 years and then it stops at 12 weeks.
Can anyone create a formula for this.
I know its complicated but I am stumped.
Thanks
Ryan
Bookmarks