We have two categories of employees, Full Time and Temporary. Full time employees earn 2.5 days of vacation every month; if a Full time employee is terminated in the first 15 days of a month (date entered in column E), they get 1.5 days of the month's accrual. If terminated after the 16th, the employee will get the full month's accrual.
Is there a way to create a formula in column Y that returns one of three values 2.5 or 1.25 for Full Time employees or 0 for Temporary.
Thanks in advance to anyone who can assist.
Bookmarks