Excel 2013: Formula to Count # of Days (Mon - Sat) 2

[beadedbytes]

Our work week is Mon through Sat (instead of Mon through Fri).

Is there a formula (Excel function or created formula) that will count the number of workdays including Saturday but excludes Sun?

Thanks in advance for feedback.

 

[Deniall]

I have never used it, but the function NETWORKDAYS.INTL looks to have been designed for exactly your problem.[ ] In effect it allows you to define your "weekend" to be any combination of the days in the week.

 

[beadedbytes]

It worked. Thank you!!!

 

[SkipVought]

Good tip, Deniall! Yours is the solution to use!

But I lost some sleep last night thinking about a formula solution, and it paid off...
[tt]
=IF(MOD(start,7)<MOD(end,7),ABS(MOD(start,7)-MOD(end,7)),6-(MOD(start,7)-MOD(end,7)))+INT((end-start)/7)*6
[/tt]



Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[mscallisto]

Nice post Deniall