I have a formula that works out how many days it is until an employee's 2015 anniversary date, once it passes that date it becomes negative. When it becomes 0 or negative, it changes to "Congratulations!!".
BUT when I have a new employee, because we're looking at 2015 anniversaries and since they were hired in 2015, they immediately become "congratulations".
I added a column and wrote =IF(A2<365, "new", "old") and thought maybe if I could find a formula that requires both column A to be negative and column B to be "old" for it to show "Congratulations" or if they were Colum A negative and Column B "new" I could show "Welcome".
I hope that makes sense.
Bookmarks