I want to display a blank field in the calculated column if both the reference fields are blank, but SharePoint displays the default date as
Formula I used in Calculated column:
=IF(ISBLANK([Actual Release Date]),TEXT([Forecast Release Date],"dd-mmm-yyyy"),TEXT([Actual Release Date],"dd-mmm-yyyy"))
If actual release is blank then it should consider the forecast release in the calculated column, if both dates are available then it should take the actual release date.
But when both the reference fields are blank, then it should leave the calculated value as blank instead of giving the default date (30-Dec-1899).