PDA

View Full Version : countifs column with date



wilg19
11-29-2017, 06:16 PM
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.

p45cal
11-29-2017, 06:40 PM
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.