View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
George Ray George Ray is offline
external usenet poster
 
Posts: 1
Default WORKDAY() Function Equivalent with SUMPRODUCT()

I am looking for an equivalent to the WORKDAY() function that does not need
the analysis toolpak. I send a spreadsheet that uses it extensively, to many
people, many of whom do not have the toolpak set up. I think there is an
equivalent that uses SUMPRODUCT(), but I cannot find it. I have a table of
holidays I can use, and I can set up a table of weekends if I need to.