I am creating a list to determine how long it is taking to review a document. I have a column named Due Date and a Column named Review Complete.
I want to calculate the difference between the two. The DATEDIF function works but only if the end result is a positive value.
I want to also know when someone creates the review early but this then creates a negative number. The negative value on the list is displayed as #NUM!.
I need to know what the negative value is to run metrics.
How do I write the calculated formula to show me negative numbers. =DATEDIF(Due-Review Complete),"D").
