Saturday as workday
Solved/Closed1 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
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. 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))
Dec 8, 2011 at 05:59 AM