Programm Auto filter for overdue time

[Hannes]

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

 

[venkat1926]

you can have a helper column. suppose the dates are in A2 down(A1 is heading)
in B2(or any other free column) type a formrula
=A2-TODAY()
copy B2 down
now autofilter the range including the helper column B to suit you.with criteria in values of column B