Another NETWORKDAYS question...

KanMan

Board Regular
Joined
Dec 4, 2005
Messages
100
I have the following formula:

=NETWORKDAYS(startdate,enddate,Holidays)

Holidays is a range with the usual Federal Holidays. This works fine if each cell in the range has a date value. However it doesn't work if any cell is blank. For example Monday, 26th December is a Holiday this year but wont be next year, in which case it will be blank. My formula for calculating whether it is a holiday or not is:

=IF(WEEKDAY(XMA)=1,XMA+1,"")

The blank cell generates a #VALUE! error.

How can I make the formula ignore a blank cell.

Thanks.
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,119,129
Messages
5,576,263
Members
412,710
Latest member
Maged elmasry
Top