SOLVED - Error with WORKDAYS() formula

I thought some might have the same issue…

I wanted to use the formula:

  • IF(AND({Date Completed},{Start Date}), WORKDAYS({Date Completed},{Start Date})-1,""). But, I would get an error if either date was missing.

I got it to work with the following:

  • IF(AND({Date Completed},{Start Date}),WORKDAYS(LEFT(CONCATENATE({Date Completed},TODAY()),10),LEFT(CONCATENATE({Start Date},TODAY()),10))-1,"")
1 Like