Saturday as workday
Solved/Closed1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
18 Feb 2010 à 12:24
18 Feb 2010 à 12:24
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))
8 Dec 2011 à 05:59