Formula to calculate how many weekend days

[treeppm]

Anyone can guide me how to count total week end days between selected dates?.
in the following what formula we have to write to in B5 to get result like that
[TABLE="class: cms_table_grid"]
<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]weekend days
[/TD]
[TD]2
[/TD]
[/TR]
</tbody>[/TABLE]


Kind Regards

 

[Sathish G]

Hi you use this =SUM(INT((WEEKDAY(B1-{1,7})+B2-B1)/7))

B1 and B3 is start date
B2 and B4 end date

example below:

Start date 05-06-2019 =SUM(INT((WEEKDAY(B1-{1,7})+B2-B1)/7))
end date 07-06-2019
Start date 10-06-2019 =SUM(INT((WEEKDAY(B3-{1,7})+B4-B3)/7))
end date 13-06-2019
Total weekends 0

 

[treeppm]

Kindly note. You should not touch anything from B1 to B4 values. it has other things.
I don't know am I making clear question or not. Please note it

from 2019/06/05 to 2019/06/17 it has 4 days ( 2 saturday and 2 sundays)

If the range is 2019/06/05-2019/06/17 it should give result 4
that's what I want.

Kind Regards

 

[treeppm]

Hi you use this =SUM(INT((WEEKDAY(B1-{1,7})+B2-B1)/7))

B1 and B3 is start date
B2 and B4 end date

example below:

Start date 05-06-2019 =SUM(INT((WEEKDAY(B1-{1,7})+B2-B1)/7))
end date 07-06-2019
Start date 10-06-2019 =SUM(INT((WEEKDAY(B3-{1,7})+B4-B3)/7))
end date 13-06-2019
Total weekends 0

You just copied the formula from extended office webpage?.

 

[footoo]

See also : https://www.mrexcel.com/forum/excel-questions/1101947-formula-calculate-how-many-weekend-days.html

 

[footoo]

.

 

[Matty]

This thread is a duplicate of the following:

https://www.mrexcel.com/forum/excel-questions/1101892-missing-days-without-weekends.html

treeppm - Please keep questions of the same nature within the same thread - it prevents potential helpers from wasting time if a question has already been answered elsewhere.

 

[AhoyNC]

Maybe something like this.
In the formula A1 is the start date and A4 is the end date.

Excel Workbook
	A	B
1	6/5/2019
2	6/7/2019
3	6/10/2019
4	6/13/2019
5		2
Sheet

 

[treeppm]

Sorry for posted in two threads, I thought it's different question that's why most of the persons didn't answer in that thread. here after will strictly follow the rules and guides.


@AhoyNC
Thank you for your guidance bro. working perfecfet

 

[AhoyNC]

You're welcome. Thanks for the feedback.