How to Pull contracts with Dates that are expiring within a week

[Anonymous]

I have contracts that are about to expire. As shown in the excel snap below, I want to add an expression that will identify only those contracts (contract end date will be the relevant field) that expire within a week. How do I do that.

[ramoncova06]

you can change the one liner I so instead of ">" to "<"

only({<[Contract End Date] = {'<$(=(today()+7))'}>}[Contract #]

[Anonymous]

See if this is what you want

[Anonymous]

Thank you very much Ramon & Michael. I was working on another filter so havent looked at your suggestions yet. But I will soon and update it here. However, now there is one more condition, which is----- Contracts beginning on say Feb1st through 1 week from today. So now we have a range unlike before. which is the only thing that has changed. Let me know if this can be implemented.