I am using a calculated column to show how many days are left before we receive a product. I am using the following formula for that:
IF([Product Expected],(DATEDIF(Today,[Product Expected],"d")),"NA",(DATEDIF(Today,[Product Expected],"d"))
It shows correctly how many days are left but it shows an error when it is past due (#NUM! - I guess because of the negative value?). My regular expressions knowledge ends here. I would like to change this formula to say "Past Due" instead of an error. How should it look like? Thanks!