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 2019-10-31.

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.


How about this, assuming the dates are in column B of Table 1. The MATCH function returns 3, the location of 9/30, which is the date before the match. Add 1. Then use INDEX to get the value of cell 4.

INDEX(Table 1::B,MATCH(NOW(),Table 1::B)+1)

  • Thanks! It looks like that did it!! – Samer Oct 14 at 21:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .