Hi,


can any please advise of the syntax required to amend the formula =DATEVALUE(TRIM(Input!B2)) to include ISERROR to prevent #VALUE! being returned.

Any assistance would be greatly appreciated

Many thanks in advance


Regards


Rob