I'm using SharePoint 2010. Right now I have a calculated column which displays in days the difference between ColumnDate1 and ColumnDate2 as follows:
But sometimes I get an error "#NUM!" when ColumnDate1 is greater than ColumnDate2.
How do I do the following for the same calculated field:
1- Display "NO DATA" when EITHER columns is blank OTHERWISE provide number of days.
2- Display "NOT LATE" when Date1 is greater than Date2, OTHERWISE provide number of days.
Thank you for your help!