Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Formula to calculate how many weekend days

  1. #1
    Board Regular
    Join Date
    Jun 2015
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #2
    New Member
    Join Date
    Aug 2017
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #3
    Board Regular
    Join Date
    Jun 2015
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #4
    Board Regular
    Join Date
    Jun 2015
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula to calculate how many weekend days

    Quote Originally Posted by Sathish G View Post
    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?.

  5. #5
    Board Regular
    Join Date
    Sep 2016
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Formula to calculate how many weekend days


  6. #6
    Board Regular
    Join Date
    Sep 2016
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Formula to calculate how many weekend days

    .
    Last edited by footoo; Jun 23rd, 2019 at 08:20 AM.

  7. #7
    Board Regular
    Join Date
    Feb 2007
    Location
    England
    Posts
    3,704
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #8
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,258
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default 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.

    AB
    16/5/2019
    26/7/2019
    36/10/2019
    46/13/2019
    5 2

    Spreadsheet Formulas
    CellFormula
    B5=NETWORKDAYS.INTL(A1,A4,"1111100")


    Excel tables to the web >> Excel Jeanie HTML 4

  9. #9
    Board Regular
    Join Date
    Jun 2015
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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
    Last edited by treeppm; Jun 23rd, 2019 at 04:13 PM.

  10. #10
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,258
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Formula to calculate how many weekend days

    You're welcome. Thanks for the feedback.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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