Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Number Of Weekdays Between Two Dates

  1. #1
    Six Strings Guest

    Number Of Weekdays Between Two Dates

    Here is a formula to calculate the number of weekdays between two dates, inclusive. That is, the number of weekdays between Monday and the next day are 2. I am using this for a schedule spreadsheet where I need to see working days.

    In this example, cell A2 contains the earlier date and B2 contains the later date.

    =MAX(WEEKDAY(B2,2)-WEEKDAY(A2,2),0)+1+INT((B2-A2)/7)*5

    If you don't want it to be inclusive you can remove "+1".

    This, of course, does not take holidays into account.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,345

    Re: Number Of Weekdays Between Two Dates

    Thanks for sharing
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  3. #3
    Join Date
    24th April 2007
    Location
    England
    Posts
    675

    Re: Number Of Weekdays Between Two Dates

    Formula doesn't work, though

    A2 = Friday 11th May 2007
    B2 = Tuesday 15th May 2007

    formula gives a result of 1

    For a count of weekdays between two dates without using NETWORKDAYS

    =SUM(INT((WEEKDAY(A2-{2,3,4,5,6})+B2-A2)/7))

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2003
    Location
    UK
    Posts
    4,684

    Re: Number Of Weekdays Between Two Dates

    Intresting - jiuk uses NETWORKDAYS even in Access I use NETWORKDAYS. Will have to remember to test these next week in my real work so Jack can test and compaire

    jiuk

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Six Strings Guest

    Red face Re: Number Of Weekdays Between Two Dates

    I found some time after posting that this didn't work. I developed a formula that does work, though it's rather complex. If anybody really wants to see it I'll pull it out of the junk drawer.

    Then I discovered the NETWORKDAYS function and figured there was no point in continuing to post updates to this thread.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Count Number Of Weekdays In Given Month & Year In Access
    By prajesh in forum Excel and/or Access Help
    Replies: 1
    Last Post: January 12th, 2008, 22:29
  2. Weekdays Between 2 Textbox Dates
    By Foreverlearning in forum EXCEL HELP
    Replies: 5
    Last Post: December 17th, 2007, 17:19
  3. Replies: 13
    Last Post: August 28th, 2006, 20:29
  4. Weekdays between 2 dates
    By Joozh in forum EXCEL HELP
    Replies: 5
    Last Post: September 15th, 2004, 17:45

Bookmarks

Posting Permissions

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