|I need a formula....|
I have 3 ranges of cells (365, one for everyday of the year).
In column A I want the cell to say either "CURRENT" or "LEAVER". I want this to say current unless told otherwise from a cell on another page specifying the particular leaving date, which will obviously vary person to person, without changing the status in the cells where the employee was active.
Column B is the dates
Column C is Information I need calculating, but only if the employee status read "CURRENT", which is an easy SUMIF formula.
But column A I am struggling with
So far I have an IF function we that I can gives me both "CURRENT" and "LEAVER" :
=IF('New Starter Info'!$H$2<>"","LEAVER","CURRENT")
But the date changes every cell rather than just the ones after the leaving date.
Any help will be great