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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
@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 ?
 
Upvote 0
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.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,550
Messages
6,114,265
Members
448,558
Latest member
aivin

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