I have E7 through E22 with due dates. Some of the cell in the E column doesnt not have a date entered just "n/a". And i want excel to go through the dates that are in the E column and automatically find the one that is upcoming up the soonest and have it automatically entered in F4. Is there a way to do this?