0

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!

Improve this question
3
  • Are you getting any error while saving the column with this formula or are you getting wrong(unexpected) results in list view?
    – Ganesh Sanap - MVP
    Commented Sep 16, 2020 at 17:40
  • No errors from SharePoint, meaning the formula looks ok. But the results are not correct.
    – Eric High
    Commented Sep 16, 2020 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?
    – Ganesh Sanap - MVP
    Commented Sep 17, 2020 at 5:07

1 Answer 1

Reset to default
0

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])
Improve this answer
1
  • Thank you, Julie! That worked! You made my day!
    – Eric High
    Commented Sep 17, 2020 at 14:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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