I created an excel formula that convert a string into a date.
It's working as expected when a value is specified but blank cell are giving me an error so I added an IF to handle those cells.
The problem with the IF keyword is that both true and false parts seems to be evaluated. In this specific case the LEFT / MID / RIGHT keyword will each raise an error even if the "" should be used.
Is is possible to tell the IF keyword to evaluate only the value that will be used based on it's condition?
P.S. I had to convert the formula from a french version of Excel... if there's any typo please let me know.