Finding a holiday

[Cyankee]

I'm working on a spreadsheet to estimate my paycheck.
I know using =networkdays can help me find out of there is a holiday on any given week, but I need to know if it is on the mon, tue, wed, thu, fri, sat, or sun of the week so I can calculate holiday pay.
I did it once before, but ended up using three rows and 14 columns (using a table) rather than 1 row and 7 columns.
Is there a way to do this without having so many rows and columns? I feel it might require a VB Program and not functions in excel.

 

[DRSteele]

If you use function NETWORDAYS.INTL you can specify which days are declared as weekends. If you have a few minutes, watch this youtube video for an introduction to the function's use: https://www.youtube.com/watch?v=0ajwO2hrNww

 

[Cyankee]

Thanks, while it is a bit more robust, it doesn't help for what I am looking for.
But I think I figured out a way of doing it on at least one line.