I'm attempting to calculate the difference in dates (the current date & Date Opened column) only if the Status? Column reads Open or Hold. I've tried:

=IF(Status?,"Open" OR "Hold",(DATEDIF([Date Opened],NOW(),"D")))


=IF(Status?,"Open","Hold",(DATEDIF([Date Opened],NOW(),"D")))

But get a syntax error.

Help please!


Try below formula:

=IF(OR([Status?]="Open", [Status?]="Hold"), DATEDIF([Date Opened],NOW(),"D"), 0)

Instead of 0 you can put any default value you want if status is neither open nor hold.

| improve this answer | |

You can use the following formulas:

=IF(OR([Status]="Open",[Status]="Hold"),DATEDIF([Date Opened],NOW(),"D"))

Calculated Field Formulas:


| improve this answer | |

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.