Saturday as workday

[Solved/Closed]
Report
-
 Joe -
Hello,

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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Thanks. It works for me as well