How to use workday with saturday,

Closed
san - Apr 26, 2010 at 03:28 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 26, 2010 at 08:55 AM
I have only a start date , how do i inlude saturday as a working day in it.

3 replies

Blocked Profile
Apr 26, 2010 at 04:04 AM
Dear San,

Please express yourself clearly so that we get to understand the situation.

Thanks.
0
Hi San,

You might want to take a look at the following link:
https://www.excelbanter.com/excel-worksheet-functions/40045-%22saturday-work-day.html
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Apr 26, 2010 at 08:55 AM
You are not clear what you want

if you want to find days between two dates and want to include Saturday was working day, then you can use this formula

=SUMPRODUCT(1 * (WEEKDAY(ROW(INDIRECT(A2 & ":" & B2)), 3) <6))

It will get the days past, while excluding only Sunday. In this A2 and b2 have the two dates
0