Forum Discussion
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...
If there isn't a date entered in AG2, then your suggestion returns a 01/00/1900 instead of leaving the cell blank. Is there a way to keep my IF function and add the TEXT function as well?
Yes, you shall check if the cell is blank or not. Like this
IF(ISBLANK(AG2),"",(TEXT(AG2,"mm/dd/yyyy"))