Agents absence & attendance schedule - final.xlsx
I am afraid that it did not worked the way I want and it seems that I've missed expressed the right meaning.
Attached is the real document so can get a better understanding.
Please work only on January sheet.
choose from drop down menu in any given day anything and try to apply the formula you mentioned earlier.
Thanks a lot