FRIED0101
10-06-2022, 11:01 PM
Hey All.
I have a formula which I use for updating work schedule for our employees, it identifies when someone has put in either planned or unplanned leave.
This works well if the entry only appears once, but if they applied for leave and decided not take that leave and return to work the formula isn't smart enough and ignores the latest entry for that same day/person.
Here is my formula that I use.
=IF(OR(O$9="",O$9<44564,$B13=""),"",IFERROR(INDEX(Leave_Type,MATCH(O$9&" "&$B13,Leave_Outcome,0)),MID($C13,MOD(DAYS(O$9,44564),LEN($C13))+1,1)))
Also see attached spreadsheet for reference.
Any adjustments that would work would be greatly appreciated.
Many Thanks
Danny
I have a formula which I use for updating work schedule for our employees, it identifies when someone has put in either planned or unplanned leave.
This works well if the entry only appears once, but if they applied for leave and decided not take that leave and return to work the formula isn't smart enough and ignores the latest entry for that same day/person.
Here is my formula that I use.
=IF(OR(O$9="",O$9<44564,$B13=""),"",IFERROR(INDEX(Leave_Type,MATCH(O$9&" "&$B13,Leave_Outcome,0)),MID($C13,MOD(DAYS(O$9,44564),LEN($C13))+1,1)))
Also see attached spreadsheet for reference.
Any adjustments that would work would be greatly appreciated.
Many Thanks
Danny