Calculate number of days excluding Saturdays and Sundays
Results 1 to 2 of 2

Thread: Calculate number of days excluding Saturdays and Sundays
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Calculate number of days excluding Saturdays and Sundays

    Hi All,

    Would like to ask for your assistance on this if statement.J2 and H2 are 2 different dates. How do I count the difference(remaining days) without including saturdays and sundays?
    =IF(AND(M2="NA",I2="No"),0,IF(AND(I2="Yes",J2=0),NOW()-H2,J2-H2))
    Thank you
    Bryan

  2. #2
    Board Regular
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,552
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Calculate number of days excluding Saturdays and Sundays

    Try this:

    =NETWORKDAYS(A1,B1)

    This is inclusive so the start and end date is included in the count (provided they are not weekends).
    Last edited by steve the fish; Jul 31st, 2019 at 10:44 AM.
    Looking for opportunities

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
  •