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]

Formula with WORKDAYS working?

 

[footoo]

[TABLE="width: 349"]
<tbody>[TR]
[TD="width: 349"]=NETWORKDAYS(A1+1,A4-1)+2-COUNT(A1:A4)

[TABLE="width: 349"]
<tbody>[TR]
[TD="class: xl65, width: 349"]=A4-A1+1-COUNT(A1:A4)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[footoo]

This is not correct :
=NETWORKDAYS(A1+1,A4-1)+2-COUNT(A1:A4)

Instead, put in B2 =NETWORKDAYS(A1+1,A2-1), fill down and sum the results

 

[treeppm]

put in B2 =NETWORKDAYS(A1+1,A2-1), fill down and sum the results

Bro, sorry I can't understand "fill down and sum the results"
kindly explain it

Regards

 

[footoo]

Bro, sorry I can't understand "fill down and sum the results"
kindly explain it

Regards

Copy the formula in B2 and paste to B3:B4, then sum B2:B4

 

[treeppm]

Bro., that's extremely confusing me. I think you are also little bit confuse because of my table. here you go. if the table being like this
[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]2019/06/05[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019/06/07[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019/06/10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019/06/13[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Missing Days without weekend[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Missing Days with weekend[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]


Kind Regards

 

[footoo]

Bro., that's extremely confusing me. I think you are also little bit confuse because of my table. here you go. if the table being like this
[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]2019/06/05[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019/06/07[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019/06/10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2019/06/13[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Missing Days without weekend[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Missing Days with weekend[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]


Kind Regards

I don't know what's confusing you. To repeat :
• Assuming your data starts in A1 (which contains 2019/06/05)
• Enter in B2 =NETWORKDAYS(A1+1,A2-1)
• Copy B2 and paste to B3:B4
• Enter in B5 =SUM(B2:B4)

 

[treeppm]

In this example how to get result in B5 like this (showing how many weekend days between the range)

[table="width: 250, class: grid"]
[tr]
[td]2019/06/05[/td]
[td][/td]
[/tr]
[tr]
[td]2019/06/07[/td]
[td][/td]
[/tr]
[tr]
[td]2019/06/10[/td]
[td][/td]
[/tr]
[tr]
[td]2019/06/13[/td]
[td][/td]
[/tr]
[tr]
[td]weekend days[/td]
[td]2[/td]
[/tr]

[/table]

Kind Regards

 

[treeppm]

• Copy B2 and paste to B3:B4

this step confusing bro. Copy B2 ok and paste to B3:B4 mean? we have to pate it in B3 and B4 too?