OK, I am learning Excel as I go along and appreciate help in advance.

I have the following formula created. It works in creating the actual data I need however, as I need it in several cells (I dragged the formula down), it populates the cells that have no input data as 2/1/1900. I want the cells to blank until input data is, well, input.

Here is my scenario and formula (2 of those):

I need the first date of the following month in J2 based on the data input in cell G2. The formula, = IF(G2,"",EOMONTH(G2,0)+1), works great but when dragged down it populates all other cells with the 2/1/1900. I want everything blank until data is input.

The other formula is getting the last date of the month as referenced in J2, so the formula used, =DATE(YEAR(J2), MONTH(J2)+2, 0), works great but again, when dragged down it populates all other cells with the 2/1/1900. I want this blank as well until data is input.

Any and all help would be great. I have tried a few things but with no success!

Adam Reidel