Searching for the nearest date in another sheet

LJK

Hi everyone,

I would need a formula where it picks the nearest date in the past related to today's date in another sheet. To give more context, the other sheet always shows Mondays as dates. I tried Index and array but it seems not to work. Would appreciate a template. "Today's Date" cell is based on a formula, I inserted it as a reference for the formula in the highlighted cell.

L_123

=max(collect({date help column},{date help column}, @cell <= today())

L_123

=max(collect({date help column},{date help column}, @cell <= today())

LJK

super helpful thank you!