Filter function

[The Grim Discovery]

Hello Excel Overlords

Can I ask that you look upon the following formula.

=FILTER('25MarOd'!A2:N216, ('25MarOd'!M2:M216 <= DATE(2025,3,25)), "No data")

As you'll see, its filtering rows depending on the date value in Col M.

Is there anyway I can get the: DATE(2025,3,25) to populate automatically according to a date value held in cell P2? (this date might not always be today's date if that has any relevance) It annoys me - at a very, very low level - that I have to manually change this every week. If you could help with this absolutely non-urgent issue I'd be indebted.

Thanks

 

[saboh12617]

Hello,

But so, the formula

=FILTER('25MarOd'!A2:N216, ('25MarOd'!M2:M216 <= P2), "No data")

Does not work? Are you sure P2 holds a date?

 

[The Grim Discovery]

You're right Saboh, I was referencing P2 on another sheet. Bah.
Thank you.