=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)

here is a simple way how to achieve it:

  • create SharePoint Calculated column
  • formula: =[Renewal Date]-TODAY()
  • outcome: Number, decimal places: 0

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.