Closest Date in the Past

LJK

Hi,

I am currently building a ranking that I will display in a Dashboard. I need to grab data from another sheet that is the closest in the past to keep it up to date.

Any suggestions for a formula?

Paul Newcome

Try something like this...

=MAX(COLLECT({Other Sheet Date Column}, {Other Sheet Date Column}, @cell < TODAY()))

Yanis Kyr

Are you trying to fetch a single row from the other sheet?

By "closest in the past" do you mean the most recent entry as in the date that is closest to the dynamic "today"?

Yanis.

LJK

Thanks for your support in advance!

I would like to have it dynamic from today.

Paul Newcome

Try something like this...

=MAX(COLLECT({Other Sheet Date Column}, {Other Sheet Date Column}, @cell < TODAY()))

LJK

Thank you!

Paul Newcome

Happy to help. 👍️