Filter function with dates

[mnsportsfan]

I need help using the filter function formula to filter out dates that older than X amount of days. In my example I have my data in columns A through T. In columns Z through AS I'm using the filter function based on multiple criteria. The one criteria I can't figure out is how to filter out the dates from column T. I'd like to filter out anything that is X amount of days from today and older.

I figured it would be something with DateValue but can't seem to get it to work.

[PeteABC123]

mnsportsfan:

You can create a helper column to calculate the difference between today and the date in col. T. Then apply your filter CTRL + SHFT+L.

Please Login or Register  to view this content.

Copy down.
Pete