I have a column of data (formatted as a date). It stands for the days of the year for which I am missing information. I need a formula that will read through that column and copy the start and end dates for all the different date ranges within that column, onto two new columns. I've attached an image of the workbook with the column that I currently have (Column A) and what I would like my end results to be (Columns B and D). Thanks in advance.

Sample workbook.png