Saturday as workday
[Solved/Closed]1 reply
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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. 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))
Report
Joe
Thanks. It works for me as well
