Consulting

Results 1 to 2 of 2

Thread: countifs column with date

  1. #1
    VBAX Regular
    Joined
    Jan 2016
    Posts
    13
    Location

    countifs column with date

    Hi, have to find how many instances of a name in one column within a date range from another column that is within 7 days of today.

    eg

    Jill 30 11/28/2017
    Ken 47 11/28/2017
    Sally 13 11/28/2017
    kari 618 11/28/2017
    Colleen 24 11/28/2017
    Colleen 24 11/28/2017

    in a third column I need to count of how many instance of the name in column 1 that occur within 7 days of today in column 2.

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    Something like this:
    =COUNTIFS(A1:A102,E1,B1:B102,">=" & TODAY()-7,B1:B102,"<=" & TODAY()+7)
    where E1 contains a name.
    Supply a file and you'll get a more definitive answer.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Posting Permissions

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