Dave has given you the formula.

In your image you indicated that there was data for more than one year: if so, use Excel data (01/06/2017) for June 2017 to identify the year.

And of course the formula would need to be modified.