You have to use NETWORKDAYS for what you want, but you have to use an
Add-In. Go to Tools-Add-Ins-Analysis ToolPak
The function works like this:
NETWORKDAYS(start_date, end_date, holidays)
This returns the value of the amount of days EXCLUDING weakends and
holidays. You can add as many holidays as you want. Just keep in mind
that when you have more than one the function would look like:
NETWORKDAYS(start_date, end_date, {holiday1, holiday2, holiday3, etc})
For the example you gave:
=NETWORKDAYS(8/15/05, 1/12/06, B25:B28)
Hope this is what you're looking for.
--
malik641
------------------------------------------------------------------------
malik641's Profile:
http://www.excelforum.com/member.php...o&userid=24190
View this thread:
http://www.excelforum.com/showthread...hreadid=387692