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:

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
=NETWORKDAYS(A1+1,A4-1)+2-COUNT(A1:A4)

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

<tbody>
</tbody>

<tbody>
</tbody>
 
Last edited:
Upvote 0
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:
Upvote 0
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
 
Upvote 0
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)
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,937
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top