Missing days with and without weekends

[treeppm]

Hi fellows
I would like to know the missing day between the range that exclude weekends(Saturday, Sunday)

in the following example from the date range A1 to A4 what is the formula we have to write in B2 and B4 to get result like this?

[TABLE="class: grid, width: 350, align: left"]
<tbody>[TR]
[TD]2019/06/05[/TD]
[TD]Missing Days with out week end[/TD]
[/TR]
[TR]
[TD]2019/06/07[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2019/06/10[/TD]
[TD]Missing Days with week end[/TD]
[/TR]
[TR]
[TD]2019/06/13[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]


Kind Regards

 

[treeppm]

@Matty THank you so much for the guidance bro. Yeah, it's really helped and I got some Idea from.

Kind Regards

 

[footoo]

@Matty THank you so much for the guidance bro. Yeah, it's really helped and I got some Idea from.

Kind Regards

Does it still do what you need if you change, for example, 15/4/2019 to 14/4/2019 ?

 

[treeppm]

Does it still do what you need if you change, for example, 15/4/2019 to 14/4/2019 ?

No bro, I got lots of Ideas because of your and other brothers helps, Thank you so much for best assising, I've another doubts to ask, will ask here soon.