MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excluding holidays


Posted by Judy on September 10, 2001 5:49 AM

when i use the formula =networkdays(a1,b1,holidays) where/how do I define my list of holidays to exclude?

Thanks!


Posted by Tom Urtis on September 10, 2001 6:01 AM

Judy:

The list of holiday dates is something you'd need to set up in a separate range, say in D1:D10. So your formula would be:
=NETWORKDAYS(A1,B1,D1:D10)

Tom U

Posted by Robb on September 10, 2001 6:09 AM

Judy

Just make a list of the holidays somewhere else in the workbook and then refer to it.

e.g. if the list is in, say, Sheet1("I1:I6")

Start date is in A1
End Date is in B1
In C1 type =Networkdays(A1,B1,I1:I6)

Any help?

Regards

Posted by Judy on September 10, 2001 8:03 AM

Thanks Robb and Tom!

It works!

Judy