calculating day intervals, omitting 1 given day

[gregz12345]

I'm looking to calculate the days of the week between 2 sets up days, while not factoring in Saturdays.

For example below (with service days being the result):


[TABLE="width: 212"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]Service Days[/TD]
[/TR]
[TR]
[TD="align: right"]30-May[/TD]
[TD="align: right"]3-Jun[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[DRSteele]

Try this, where May 30, 2019 is in A2 and June 3, 2019 is in B2.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=NETWORKDAYS.INTL(A2,B2,17)-1[/FONT]

 

[gregz12345]

I don't believe this eliminats JUST saturdays.

Try this, where May 30, 2019 is in A2 and June 3, 2019 is in B2.

[FONT=Verdana]=NETWORKDAYS.INTL(A2,B2,17)-1[/FONT]

 

[DRSteele]

That is precisely what it does. The argument [weekend] set at 17 eliminates Saturdays.

See here
https://support.office.com/en-us/ar...pId=xlmain11.chm60568&ui=en-US&rs=en-US&ad=US

 

[gregz12345]

That is precisely what it does. The argument [weekend] set at 17 eliminates Saturdays.

See here
https://support.office.com/en-us/ar...pId=xlmain11.chm60568&ui=en-US&rs=en-US&ad=US

I miscounted on my end in a few other examples, my apologies. Thank you!

 

[DRSteele]

You're welcome. I'm glad it's working for you.

 

[gregz12345]

Just to confirm, if just sundays were to be omitted, the resulting formula should read: =NETWORKDAYS.INTL(A2,B2,11)-1 ?

 

[DRSteele]

That is so. Check this out. https://youtu.be/yk1O3O-Y8sA