title: How to fill blank cells in Excel with the date of 30/06/YEAR by picking the year from the cell in the next column
body: <p>Consider the following table:</p>
  <p><a href="https://i.stack.imgur.com/6rB9P.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6rB9P.png" alt="enter image description here" /></a></p>
  <p>I have a series of blank cells with missing data. From this missing data I only have the year in the next column. I need to fill any blank cells with a standard day/month of 30/06. The year of each cell however needs to be the year in the next column. The attached file shows how my data is arranged. So at cell B 2091, the date shall be 30/06/2011 while for cell B 2098 the date shall be 30/06/2018 and at cell B 2100 the date shall be 30/06/2008.</p>