Thread: NETWORKDAYS alternative, for use without Analysis ToolPak
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Olly Olly is offline
external usenet poster
  
Posts: 8
Default NETWORKDAYS alternative, for use without Analysis ToolPak
I'm trying to build a formula to calculate the number of working days /
hours between 2 specified dates. This will be used in multiple workbooks, by
various users, who may not have the ability to run code or install the
Analysis toolpak.

I've consulted http://www.cpearson.com/excel/DateTimeWS.htm and modified the
formula accordingly - so far so good! But this still relies on the
NETWORKDAYS function from the Analysis ToolPak. How can I rewrite this
formula to avoid the networkdays function?


--
Olly


Reply With QuoteReply With Quote