max-with-condition
Topic | Replies | Views | Activity | |
---|---|---|---|---|
How can I find the latest date in a non-contiguous range (e.g. C5, C10, C15...) that is also earlier than the date in another cell (e.g. A1)? |
![]() ![]() ![]() |
6 | 2311 | June 23, 2019 |
max with condition |
![]() ![]() ![]() |
4 | 2067 | July 31, 2021 |