=IF(ISERROR(DATEDIF(NOW(), [Renewal Date], "d")), -DATEDIF([Renewal Date], TODAY(), "d"))
I am using the formula above and this is correctly showing me the items that are past due and for items that are current I am getting a message of No. I want the field to show how many days until the item is due by showing a negative number.
The formula I use in excel is
=IF(H3<>"", TODAY()-H3, TODAY()-F3)