How to use workday with saturday,
Closed
san
-
Apr 26, 2010 at 03:28 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 26, 2010 at 08:55 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 26, 2010 at 08:55 AM
3 responses
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
You might want to take a look at the following link:
https://www.excelbanter.com/excel-worksheet-functions/40045-%22saturday-work-day.html
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 26, 2010 at 08:55 AM
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
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
