Thread: Workdays
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Workdays

See the Excel help for the NETWORKDAYS and the WORKDAY function

If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"John Flynn" wrote in message ...
I am using Days360 function within Excel to extract the
number of days that an item is open. However, the purist
in me would like to exclude weekends and holidays so that
we have a true workdays open calculation.

Thanks