I have an excel sheet with data for agents attendance. I use the following formula however I need it to be edited.
Ill lay it out like this, at our company we have the following rules and I would like for this sheet to be automated:
Partial absence & Tardies Expires off in 3 months
Absence falls Expires after 6 months
Unexcused is not waived
Excused is Waived
Based off these rules, I would like the letter in column F to update!
E = Expired
Y = Yes
N = No
Any help would be greatly appreciated! I have attached a sample worksheet to help you understand what I am dealing with!
Bookmarks