MrExcel.com - Your One Stop for Excel Tips & Solutions

NETWORKDAYS formula and holidays

Posted by Matthew Schmitt on April 09, 2001 6:20 AM

I got my NETWORKDAYS formula to work, but I didn't have any holidays in it. I added on, and it still worked, but I'm not sure of the syntax if I want to put several holidays in the formula. Here is what I have so far

=NETWORKDAYS((A1),(TODAY()), ("4/9/01"))

Posted by Aladin Akyurek on April 09, 2001 7:00 AM

Put the dates of the holidays in a set of cells, say c1,c2,c3,.. so on. Select these cells and name the selected range HOLIDAYS via the Name Box.

Then change the formula to:

=NETWORKDAYS(A1,TODAY(),HOLIDAYS)

Aladin