+ Reply to Thread
Results 1 to 6 of 6

Counting the different ways of the week between 2 dates

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    69

    Counting the different ways of the week between 2 dates

    I am pretty good with formulas but I am kind of stuck on thinking of a good method to use for this problem.

    If I have 2 dates, let's say 10/9/14 and 20/9/14, I want to have a table which has the days of the work week Monday, Tuesday, Wednesday, Thursday, Friday, and I want there to be a formula that counts how many of that work week day was in between those 2 dates. For example using the above problem, the answer for Monday would be one as there is only one monday between those dates. How would I go about doing that? Your help is much appreciated!

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Counting the different ways of the week between 2 dates

    http://www.mrexcel.com/forum/excel-q...ml#post1557217
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    10-10-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Counting the different ways of the week between 2 dates

    Thanks so much mikeTRON! This is just what I was after.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Counting the different ways of the week between 2 dates

    If you're using Excel 2010 you can use the NETWORKDAYS.INTL function.

    Data Range
    A
    B
    C
    1
    9/10/2014
    9/20/2014
    2
    Mon
    1
    =NETWORKDAYS.INTL($A$1,$B$1,"0111111")
    3
    Tue
    1
    =NETWORKDAYS.INTL($A$1,$B$1,"1011111")
    4
    Wed
    2
    =NETWORKDAYS.INTL($A$1,$B$1,"1101111")
    5
    Thu
    2
    =NETWORKDAYS.INTL($A$1,$B$1,"1110111")
    6
    Fri
    2
    =NETWORKDAYS.INTL($A$1,$B$1,"1111011")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Registered User
    Join Date
    10-10-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Counting the different ways of the week between 2 dates

    Another great solution, thanks Tony, I will have a play with that as well!

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Counting the different ways of the week between 2 dates

    You're welcome. Thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] from date data counting how many dates fall in current week
    By KK1234 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-03-2013, 08:13 AM
  2. counting the number of dates that fall within a given week
    By john dalton in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-11-2013, 05:40 PM
  3. [SOLVED] Counting how many dates in a range fall into this week and last week
    By AneelK in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2013, 09:38 AM
  4. Counting a Football Team's Record Week by Week
    By PASay1975 in forum Excel General
    Replies: 6
    Last Post: 09-05-2011, 11:16 AM
  5. Replies: 6
    Last Post: 02-02-2009, 01:57 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1