I have three calculated fields using the DateDiff formula named [DateDiff1], [DateDiff2], [DateDiff3] and I have a fourth calculated field that sums up the three DateDiff fields named [Total]. The total field works fine when all three DateDiff fields have data but when any one of the three DateDiff fields is blank then the Total field also returns a blank. How can I make the [Total] field return a result even if one or more of the DateDiff fields are blank?
Thanks,
Chris