+ Reply to Thread
Results 1 to 6 of 6

counting the number of dates that fall within a given week

  1. #1
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    counting the number of dates that fall within a given week

    Hi,

    I am trying to count the number of dates that occur within a date - between the start date of a week and the end date of a week.

    Please see attached sheet.
    Attached Files Attached Files

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: counting the number of dates that fall within a given week

    Try this in H4

    =COUNTIFS($A$2:$A$23,">="&F4,$A$2:$A$23,"<="&G4)

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: counting the number of dates that fall within a given week

    For 2003 and earlier versions

    =SUMPRODUCT(($A$2:$A$23>=F4)*($A$2:$A$23<=G4))

    Although I see you've attached a xlsx file which means you have later version
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Re: counting the number of dates that fall within a given week

    Hi forgot to add a column alongside the dates list every other date should have the word induction next to it and only the dates with induction next to them need to be counted.

  5. #5
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: counting the number of dates that fall within a given week

    Use
    =COUNTIFS($A$2:$A$23,">="&F4,$A$2:$A$23,"<="&G4,$B$2:$B$23,"Induction")
    or
    =SUMPRODUCT(($A$2:$A$23>=F4)*($A$2:$A$23<=G4)*($B$2:$B$23="Induction"))

  6. #6
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Re: counting the number of dates that fall within a given week

    Fnatastic Thank You - where is the * to say thanks BTW?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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