# Thread: Formula to calculate how many weekend days Thanks:  2 Post #5299026 (1)Post #5298879 (1) Likes:  3 Post #5298923 (1)Post #5299026 (1)Post #5299100 (1)

1. ## Formula to calculate how many weekend days

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
 2019/06/05 2019/06/07 2019/06/10 2019/06/13 weekend days 2

Kind Regards

2. ## Re: Formula to calculate how many weekend days

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

3. ## Re: Formula to calculate how many weekend days

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

4. ## Re: Formula to calculate how many weekend days

Originally Posted by 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
You just copied the formula from extended office webpage?.

.

7. ## Re: Formula to calculate how many weekend days

This thread is a duplicate of the following:

https://www.mrexcel.com/forum/excel-...-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.

8. ## Re: Formula to calculate how many weekend days

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

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

 Cell Formula B5 =NETWORKDAYS.INTL(A1,A4,"1111100")

Excel tables to the web >> Excel Jeanie HTML 4

9. ## Re: Formula to calculate how many weekend days

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

10. ## Re: Formula to calculate how many weekend days

You're welcome. Thanks for the feedback.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•