0
=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)
Lukas Nespor
  • 1,661
  • 1
  • 10
  • 18
Patrick
  • 1
  • 1

1 Answers1

0

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

Zdeněk Vinduška
  • 2,889
  • 2
  • 12
  • 24