-
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.
-
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
-
Forum Rules