Date Occur
01-May Y
02-May Y
03-May N
04-May Y
05-May Y
06-May Y

The answer of the formulae is 04 May. Reason: first search for the latest string of dates with consective Y (i.e 04-May to 06-May) and then choose the earliest date in this series = 04-May