Calculation of days between dates.
Simple enough--except when one of the dates is missing. If one date is missing, the result is an extraneous number like +/- 733810.
If date/dates are not complete, how can I get the results of the calculation to be “Unknown” rather than getting an extraneous number?
Having the actual date is not possible in some cases. Sample calculations: 2009-2006= 0; No Date-1/31/2009= 733437; 5/17/2010-1997= 733909; 9/1/2009-No Date= -733651; No Date-No Date= “Blank“.