Skip to main content

Hello-


I am trying to see the lead time between two dates and this is the function I am using - IF({DATE ENTERED},WORKDAY_DIFF({DATE ENTERED},{DATE SHIPPED}),’’").


It returns the lead time number just fine when both of the date fields are entered, it;'s when I have a blank space it still shows #ERROR.


Help Please!


Thank you.


SG

Hi @SCOTT_GARDNER - you need to check for DATE SHIPPED too:


IF(

  AND({DATE ENTERED}, {DATE SHIPPED}),

  WORKDAY_DIFF({DATE ENTERED},{DATE SHIPPED})

)

With this check, an empty field in either or both of the date fields produces an empty result:



You also don’t need the final part of the IF statement (the empty quotes), unless you want to do something if the dates don’t exist. As an aside your quotes are “formatted”, not plain text, which also might be causing a problem.


JB

Perfect, thank you!!!

Reply


Terms & Conditions