December 05, 2012

SharePoint Calculated Column from Date

When building a calculated date column SharePoint will show "12/30/1899" if the source field is null.  Instead, to display the calculated column as blank, an ISBLANK statement inside an IF statement can be used:

=IF(ISBLANK([DATE_COLUMN]),"",[DATE_COLUMN])