I have a spread sheet with dates running across the columns .e.g H11 = 01/09/12 H12 02/09/12 etc.
The columns have a variety of upcoming events
The cell which corresponds with the event and the date is marked with a letter 'e'

What I'm looking for is that in the G column the most upcoming date for the event is shown e.g. with the event 'Breakfast' which happens once a month I want it the cell in column G to say the next due date e.g. 03/04/12, but once that date has passed I want it to show April's date e.g. 07/04/12 (corresponding to the marked event dates)

Hope that is clear

Thanks