Using the following:

"If Authorization Date is null, calculate the difference between Receive Date and today; If Authorization Date is not null, calculate the difference between Receive Date and Authorization Date"

This formula was tried but generated bad results:

=IF(ISBLANK([Authorization Date]),DATEDIF([Received Date],TODAY(),"d"),DATEDIF([Authorization Date],[Received Date],"d"))

Any insight / help would be appreciated!

  • Are you getting any error while saving the column with this formula or are you getting wrong(unexpected) results in list view? Sep 16 '20 at 17:40
  • No errors from SharePoint, meaning the formula looks ok. But the results are not correct.
    – Eric High
    Sep 16 '20 at 18:00
  • Can you please add any screenshot or something of list view...what are the outputs of this formula for different [Authorization Date] and [Received Date] values...and how it is wrong or what are the expected outputs? Sep 17 '20 at 5:07

The function DATEDIF(start_date,end_date,unit) says that if the start_date is greater than the end_date, the result will be #NUM!.

So try as follows:

IF(ISBLANK([Authorization Date]),[Receive Date]-TODAY(),[Authorization Date]-[Receive Date])
  • Thank you, Julie! That worked! You made my day!
    – Eric High
    Sep 17 '20 at 14:19

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.