Please see the attached file.

I'm looking for the column 'Earliest Date' (Column G) to automatically update when the next event is happening. Currently there is a formula in the column which makes it record the earliest date and event happens (an event is marked by an E in the relevant cell). The problem is I don't just want the earliest date recorded I want it to be the earliest date in relation to today's date. e.g. now First Wednesday should be showing July's date rather than still showing May's date.

I'm assuming I'll need code to work this but not sure where to start.

Many thanks

Paul