Searching for the nearest date in another sheet

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.

Best Answer

  • L_123
    L_123 ✭✭✭✭✭✭
    Answer ✓

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

Answers

  • L_123
    L_123 ✭✭✭✭✭✭
    Answer ✓

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

  • super helpful thank you!