The business wants two dates to show up in one field in a SharePoint 2013 List.
I have created a calculated column which combines the two dates but I run into issues if one of the dates isn't filled out. I can get a return of "NA" if one or both of the date fields is completed but I can't get it to display if only one of the dates is completed.
Here is what I have so far.
=IF(ISBLANK([Audit Date 2]),"NA",IF(ISBLANK([Audit Date 1]),"NA",TEXT([Audit Date 1],"mm/dd/yy")&" & "&TEXT([Audit Date 2],"mm/dd/yy")))