View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Business Days Including Holidays

Don't use NETWORKDAYS(), use WORKDAY(). Look in HELP for details.

--
Kind regards,

Niek Otten

"Dmorri254" wrote in message ...
| Hello,
|
| I am trying to calulate days to ensure a task was done in 1 business day or
| 5 business days for particular groups. I know that I can use NETWORKDAYS but
| here is the issue:
|
| If a holiday is returned,within a range of dates, how do I find the next
| business day and add it to tell me if i day or 5 days?
|
| Can anyone assist??