Got a column of names and a corresponding column of dates. Am trying to
figure out how to write a formula that will a) select a pre-specified name
from the first column and count the number of times it occurs BASESD ON b)
the dates in the second column if they fall within a specified range.

If the date in the date column is within (the last week), then count the
name in the corresponding name column if it's (name goes here).

Both lists have data added to them daily and I don't want to get in and have
to move ranges or anything else manually every day.

How do I do that?