Get the next date from column of dates
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)