Hello,
I have a list of employees attending various events.
I have a table of event assignments. What I need is a formula in the cell of the event start date.
Once I choose an employee, I want to verify that this employee is not already assigned within 10 day before and after the selected date.
If already assigned within this period, the cell should change color. Can anyone can assist?