Thread: Counting # of days between 2 dates excluding Fri & Sat)
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Counting # of days between 2 dates excluding Fri & Sat)

This will not work because the networkdays assumes Sat and Sun as weekends
and not Fri/Sat

I have a formula replacement for NETWORKDAYS that allows you to
specify any days as non-working days. You are not restricted to just
two non-working days. You can specify any number of days.

http://www.cpearson.com/Excel/BetterNetworkDays.aspx

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Fri, 20 Mar 2009 18:21:27 +0530, "Ashish Mathur"
wrote:

Hi,

This will not work because the networkdays assumes Sat and Sun as weekends
and not Fri/Sat
Reply With QuoteReply With Quote