Networkdays

  • Thread starter Thread starter Otaibi
  • Start date Start date
Do you mean include Sat and Sun as workdays and ignore Thu and Fri? If so,
use

=NETWORKDAYS(A1+2,B1+2)

HTH

Bob
 
I have some formulas at
http://www.cpearson.com/Excel/BetterNetworkdays.aspx that allow you to
specify any one or more days of the week to exclude from the
calculation. There are two versions of the formula -- one that
supports a list of holidays to exclude and a second one that doesn't
support holidays, but calculates faster.


Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
Back
Top