I'm a newbie when it comes to creating formulas in EXCEL. I'm trying to create a formula that will add a certain number of months to whatever date is entered in another cell. I want the cell that holds the formula to remain a true blank. The formula I came up with shows "FALSE" rather than blank
=IF(B3<>"",EDATE(B3,18))
Another formula I attempted, shows errors that I can't solve
=IF (B10=”” ,”” ,IF(B10<>0,EDATE(B10,18, ""))
Any help with solving this would be greatly appreciated
Bookmarks