Hi,
I really need you help. I don't know how to set up an excel equation.
I want to know the date of DO for worker 1,worker 2 and worker3 from 20/4/2020-3/5/2020.
For example, when I search the duty of worker1 from 20/4/2020-3/5/2020, I find the DO first by using HLOOPUP function, but I cannot export the date when the worker 1 day off.
Attached the excel.
Bookmarks