On your menu please click Tools, Add-Ins and make sure that Analysis
Tool Pak is selected. If it's not selected the NETWORKDAYS() function
returns an error.

When you say
I would also like to get rid of (skip) the holidays automatically
from the cell.
.... do you mean you want to list holidays in the formula itself?
That's possible, but a little chunky.