I used the formula that you sent and I am getting an error. It is an "invalid
name error". It seems to have a problem with NETWORKDAYS.

I have it set up such that the person inputs a date and the rest of the
cells fill in. Right now, with the current fomula, I have it so only the
work week shows. I would also like to get rid of (skip) the holidays
automatically from the cell.

Thank you,

Aviator


"Dave O" wrote:

I did it by adding the NETWORKDAYS() function to the front of your IF()
function:
=IF(NETWORKDAYS(E$23,E$23,I2:I7)=1,IF(E$23="","",I F(WEEKDAY(E$23+1,2)5,E$23+1+(WEEKDAY(E$23+1)2)*7-WEEKDAY(E$23+1)+2,E$23+1)),"Weekend/Holiday")
.... where I2:I7 is a list of Holiday dates.