Hi there,

I would need the functionality in an spreadsheet to compare to dates with an
auto filter and only show matches according to criteria. The criteria should
be:

if "date today" -5 in comparison to "date in column X" then show value,
otherwise hide value (this includes entire row)

The spreadsheet has 15 columns and need to be filtered according to the
criteria above.


Many thanks for support. I'm clearly swamped.

Cheers