No, I don't want to list the holidays in the formula. I have a column with
all the holidays (AZ2:AZ25). But, for example, I will have a row of 10 cell.
I input the first date and the next 9 cells are supposed to show the next
working dates.

I input 12/22, the next cell shows 12/23, then 1/3 (the reason it should
skip or jump to 1/3 is because of the weekends and holidays).

I have added the Analysis Tool Pak. I am no longergetting the error message.
But, I am not getting the correct dated either (if there is a date). Plaese
help.

Thank you,

Aviator


"Dave O" wrote:

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.