Hi Hope someone can assist. I want to create a formula to calculate someones Severance pay here are the rules:
Less than 3 month = 0
3 months to 1 year = 1 week
1 year to less than 3 years = 2 weeks
3 years = 3 weeks
Greater than 3 years = 3 weeks plus 1 weeks for every year worked thereafter
I have a formula that calculates the number of years worked between 2 dates (=(End Date-Start Date)/365. I need the number of weeks payable to display in Cell B18
Less than 3 month = 0
3 months to 1 year = 1 week
1 year to less than 3 years = 2 weeks
3 years = 3 weeks
Greater than 3 years = 3 weeks plus 1 weeks for every year worked thereafter
I have a formula that calculates the number of years worked between 2 dates (=(End Date-Start Date)/365. I need the number of weeks payable to display in Cell B18