AnsweredAssumed Answered

Workdays between dates including Saturday.

Question asked by tonymak on Oct 16, 2014
Latest reply on Nov 24, 2014 by Mike_Mitchell

Have found solutions to calcualte workdays (weekdays) between two given dates

Example ( 10/1/2014 through 10/15/2014 )

 

however the company i'm doing work for uses a 6 day workweek for sales, Mon through Saturday.

 

so normally the above example would be 11 workdays without saturdays.

 

any suggestions on how i can find the number of saturdays to add to the weekday calc would be great.

( 2 for the above example) making the 6 day week equal to 13 workdays starting 10/1/14 and completing 10/15/2014.)

 

 

on the other side of that the factory works a 4 day week (Mon through Friday) so i also need to be able subtract fridays as well.

Outcomes