Searching for the nearest date in another sheet
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.