If Function Date Format Changes to Serial Date
=IF((Genesis!AF2=""),"",Genesis!AF2)&CHAR(10)&IF(Genesis!AG2="","",Genesis!AG2) Genesis!AF2 is a formulated Y Genesis!AG2 is a hard entry date, 1/1/18, and formatted to be as such date. I want the formula to return as : Y 1/1/18 if true, and if not then to leave blank. Genesis!AF2 returns correctly, as Y, but Genesis!AG2 returns a Serial, as 43101. I have formatted the formula cell to match the same as the hard entry Date and still get Serial. I entered the IF statement to return a blank if the date cell is blank, and if not then to return the cell. This works, but returns a Serial Date instead of the formatted date.