Missing days with and without weekends

[manoes]

Dear Friends
I would like to know the missing days between the range that included, and excluded weekends(Saturday, Sunday)

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

2019/06/05
2019/06/07
2019/06/10
2019/06/13
Missing Days without weekend	3
Missing Days with weekend	5

Kind Regards

[XLent]

If your dates are in order (as illustrated)

B5: =NETWORKDAYS(A1,A4)-4
B6: =1+A4-A1-4

[manoes]

No brother, it's not giving right result if suppose I use more dates like this

2019/05/09
2019/05/10
2019/05/13
2019/05/15
2019/05/16
2019/05/20
2019/05/21
2019/05/22
2019/05/24
2019/05/27
2019/05/28
2019/05/29
2019/05/30

PS: I wrote the formula for this
=NETWORKDAYS(A1,A13)-4
=1+A13-A1-4

[Crooza]

Try this

Please Login or Register  to view this content.

with Control + shift + enter as an array formula

and this

Please Login or Register  to view this content.

with control + shift + enter too as an array formula.

it should also account for dates being out of order

change the range a1:a4 to suit

[manoes]

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

2019/06/05
2019/06/07
2019/06/10
2019/06/13
weekend days	2

Kind Regards

[Crooza]

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

2019/06/05
2019/06/07
2019/06/10
2019/06/13
weekend days	2

Kind Regards

This looks like a different question. Did your question above get answered? If so show this as solved and start a new question

[manoes]

No that doesn't give any solutions.
this formula gives with week end + total missing days between selected range
=(val2-val1+1-COUNT(val1:val2))
and now I would like to know How to calculate total weekend days between two range

[cbatrody]

Try the following:

=(A4-A1+1)-NETWORKDAYS.INTL(A1,A4,1)

[manoes]

Thant is fantastic bro.,
And I found another one myself.,

=SUM(INT((WEEKDAY(val2-{1,7})+val2-val1)/7))

[manoes]

Crooza and cbatrody
Thank you so much your guidances., Greatly helped.

Kind Regards

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.