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.
=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.