Forgive me, I'm new to excel. I've been racking my brain for a few days now trying to figure out how to get this to work. I need to find out how many days each "Worker" has worked. I thought using NETWORKDAYS would be perfect, because of the start and end, excluding Holidays. But because I need a bunch of info for separate people. So here is my layout... How would I go about getting the Vacations Rows into the Exclusion portion? I've tried Match, LookUP,etc... any help would be greatly appreciated...
Thanks
Screen Shot 2013-12-16 at 8.21.00 PM.png
Bookmarks