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
Bookmarks