Missing days with and without weekends

treeppm

Board Regular
Joined
Jun 3, 2015
Messages
60
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?

2019/06/05Missing Days with out week end
2019/06/073
2019/06/10Missing Days with week end
2019/06/135

<tbody>
</tbody>


Kind Regards
 
Last edited:

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
2,751
=NETWORKDAYS(A1+1,A4-1)+2-COUNT(A1:A4)

=A4-A1+1-COUNT(A1:A4)

<tbody>
</tbody>

<tbody>
</tbody>
 
Last edited:

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
2,751
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
 
Last edited:

treeppm

Board Regular
Joined
Jun 3, 2015
Messages
60
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
 

treeppm

Board Regular
Joined
Jun 3, 2015
Messages
60
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
2019/06/05
2019/06/07
2019/06/10
2019/06/13
Missing Days without weekend3
Missing Days with weekend5

<tbody>
</tbody>


Kind Regards
 

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
2,751
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
2019/06/05
2019/06/07
2019/06/10
2019/06/13
Missing Days without weekend3
Missing Days with weekend5

<tbody>
</tbody>


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

Board Regular
Joined
Jun 3, 2015
Messages
60
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 days2

Kind Regards
 

Forum statistics

Threads
1,086,101
Messages
5,387,829
Members
402,082
Latest member
AstroSpider

Some videos you may like

This Week's Hot Topics

Top