I was hoping for assistance on a formula to calculate the maximum date in a
range that is less than or equal to today()?
My ultimate aim is to then deduct this date from =today().
What I'm working with is a spreadsheet of Employees Leave Breaks and I need
to show the boss the number of days each employee has been back on site since
their last break.
=Max alone doesn't quite cut it because the range includes a list of
forecast break dates.
I also tried Index Match but couldn't manage to get it to work either.