Trying to return the entire row from a corresponding sheet based on a range
of dates. How can this be accomplished?

The range is "today( ) to today( )-21". There will be multiple entries that
meet this criteria and will vary day by day.

The range of the data is E2:E500.

Thanks

Dan