When you use
DATEDIF in a SharePoint Calculated field and the result is negative the function returns
#NUM! how can I detect that value with an
IF to branch around it?
=IF(DATEDIF(NOW(),[Proposal Status Date],"d")="#NUM!",1,2)
Ultimately, overdue "Proposals" return a negative value which isn't cool with
Thanks! I hope this makes sense.
Guess I could just compare the dates first (?) -- just asking...