I am trying to build a function that is based off of years of service by hire date. The hire date cell uses this function : =DATEDIF(B27,$C$5, "y") where B27 is the hire date cell. and $C$5 is the date value we enter to check and update the sheet.
The function needs to do the following:
I have tried multiple IF statements and can only get a return of either 1 or False. I cannot get it to go any further. Any help or suggestions on a formula?
The function needs to do the following:
Years of Service based off Hire Date | Result |
0-1 | 1 |
1-2 | 2 |
2-3 | 3 |
3+ | 4 |
I have tried multiple IF statements and can only get a return of either 1 or False. I cannot get it to go any further. Any help or suggestions on a formula?