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!
