Number of days open

Can anyone tell me why im getting an incorrect argument set error with the formula below? Im trying to determine how many days a case has remained open since it has been assigned, but want to ensure i dont include those that have a disposition date entered

=IF(AND(ISDATE([Date Assigned]@row,ISBLANK([Disposition Date]@row)),TODAY() - [Date Assigned]@row, "")

Answers

  • Cory Page
    Cory Page ✭✭✭✭✭

    Not sure if this will work for you but I would use the disposition date as my primary if statement. Here is an example hopefully it works ok for you just make sure the columns are set to Date format that can cause issues sometimes.

    =IF([Disposition Date]@row = "", TODAY() - [Date assigned]@row, "Has Disposition Date")

  • Thank you Cory! with a few minor adjustments it worked perfectly :)