Compare dates in a column and return a value if match in another column

Justin Mauzy

There are two columns that I need to count and match:

• Date of Purchase
• Lead Tech

Here is what I need the formula to do:

• If there is a name that appears more than once in the Lead Tech column, then:
• Count the number of times they appear in the last 7 days and last 30 days using the Date of Purchase column.
• Return a value of the number of times.

Thank you in advance.

Paul Newcome

Try something like this:

=COUNTIFS([Lead Tech]:[Lead Tech], @cell = [Lead Tech]@row, [Date of Purchase]:[Date of Purchase], AND(@cell>= [Date of Purchase]@row - 30, @cell<= Date of Purchase]@row))

Paul Newcome

Try something like this:

=COUNTIFS([Lead Tech]:[Lead Tech], @cell = [Lead Tech]@row, [Date of Purchase]:[Date of Purchase], AND(@cell>= [Date of Purchase]@row - 30, @cell<= Date of Purchase]@row))

Justin Mauzy

That works perfectly. Thank you for the quick response.

Paul Newcome

Happy to help. 👍️