Hi there and Happy Friday!

I am trying to calculate the time it takes an individual to get a specific type of number at the time they enroll in our program.

The formula I have is essentially, "If the individual does not have a preexisting number, calculate the time difference between the date they got the number and the date they enrolled in the program."

The formula is: IF({LO has FTN at time of Enrollment}="No",WORKDAY_DIFF({Enrollment Date},{Turned in FTN}))

That works but if “Turned in FTN” is blank, the calculation results in "#ERROR" and I hate "#ERROR".

So, that means I need to add something like, “If “Turned in FTN” = Blank, then “””. I tried adding that a few different ways but am still getting #ERROR.

Any ideas how to get rid of the #ERROR? Thanks in advance!