Yes. You' re right. There is no problem with #1. Sorry. It happens because I have used that code to insert missing dates.
The problem with # two is, there are two types of blank cells in my dataset. 1st the cells for non-31-day months (e.g.,29-30 and 31 Feb) which program is perfect on this issue and 2nd, Real missing values (e.g., 1-30 Jun 1951). And the problem is, the code is ignoring those missing values, while I need those missing values in the NEW file.

I tried to solve it myself to do not bother you more, but seems I failed to do so. Could you please help me on this as well. Thanks.