Another NETWORKDAYS question...

[KanMan]

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.

 

[Aladin Akyurek]

You could get away with:

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

 

[KanMan]

Works beautifully.

Thanks.