Saturday as workday

Solved/Closed
Jman - Feb 18, 2010 at 10:44 AM
 Joe - Dec 8, 2011 at 05:59 AM
Hello,

How do I get excel 2003 to include saturday as a weekday? I can't get workday or networkdays to include it.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 18, 2010 at 12:24 PM
Assumption
1. Start date is in col a and starts at cell a2
2. end date is in col b and starts at cell b2

Put this in cell c2 and drag down to all rows

=SUMPRODUCT(1 * (WEEKDAY(ROW(INDIRECT(A2 & ":" & B2)), 3) <6))
1
Thanks. It works for me as well
0