Trying to answer a question, right now i have a formula that calculates 12 months on to a prior field, IE:=DATE(YEAR(C6),MONTH(C6)+12,DAY(C6)), when I type this into cell (D6)...if there is nothing in cell (C6), the date formats to 12/31/1900....once i type something into C6, the date fills in to the proper date, is there a formula, or a way to format this cell so if nothing is in the cell C6, D6 shows nothing in the field.
Bookmarks