Exclude rows older than 7 days from today

[RDF25087]

Hi all -

I have a data set with a 'Date' field. The data is in the format dd.mm.yyyy.

I simply need a formula to exclude all records that are more than a week old.

Sounds simple enough?

Any help, as always, greatly appreciated.

Thanks

RDF

[Farriyajawed]

Use a filter tool to keep the records in a fixed range for the dates that you need. Make sure the column is in date format

[binu_acs · Accepted solution]

@RDF25087 One way of doing this

[RDF25087]

@binu_acs- thank you for the response. Your solutions works perfectly.

RDF