I have a table in Numbers with a column which contains dates. From that column, I'm trying to get the next date from today from that list and display it in a cell.
Assuming today is October 12, 2019, I'm expecting the value in the cell to display
I've been trying for hours, but I couldn't figure it out. I'm looking for a solution that doesn't require me to add an additional column or anything like that, just a simple (or complex) formula to place in the cell.
Edit: To clarify, the date values are entered manually and they are dates of an event. What I'm trying to achieve is in another table for the upcoming date of the next event.