I am trying to write a very simple equation as Calculated Column on SharePoint List. This equation works easily in Excel, but I'm having trouble with it on SharePoint List.
I am trying to find the difference of days from [RDC Deadline] to TODAY(), whether it's positive or a negative number (a negative number would mean that it's that many days overdue). In excel, I have a simple DATEDIF function and it provides both positive and negative numbers with no problem, but on SharePoint if the number is negative then there will be a #NUM! error. Is there any way I can go around this and get both negative and positive numbers? I tried an IF statement too but it was unsuccessful.
Thank you!