Cell A1 contains the date 2/28/15

Cell B3 contains the formula =DATE(YEAR(B4),MONTH(B4),1) - RESULT 03/01/15
Cell B4 contains the formula =B3+1 - RESULT 03/02/15
Cell B5 contains the formula =B4+1, etc... - RESULT 03/03/15

When I get to the cell where the date changes months to March (03/01/15), I want the cell to remain blank.

The idea is that each month the only cell that will be manually changed is cell A1, (that cell must be the last day of the month, because it is used in other parts of the workbook). and the dates listed in column B will only be for the current month of cell A1, in the example above February.

Thanks,