microsoft excel 2010 - How to delete days with no data?

I have the flow data for 49 years for 15 min interval. I've used pivot table to get the daily average value of flow.

After copy-pasting from pivot table and using filter to remove the blank flow cells (monthly and yearly headers), I filled in the dates to get a continuous list of the dates with the year included. However, many days have no data as shown above (e.g. 20-Jan, 26-Jan and 9-Feb). As a result, I had to check the whole data and delete those days with no data. Is there any way I can get a list of days with years included for the days with data only?

You can check the whole dataset through this link https://www.dropbox.com/s/rlrp78lj0jfk51d/Flow_Q.xlsx