I have formula (see below) that is part of a larger set of formulas but the formula below is not doing what I wanted it to do, I have a column with that has a date with the letters ETA with it like
ETA 05/26/23 and I just want to strip off the "ETA" and just leave 05/26/23 but it stays the same ETA 05/26/23 and nothing gets stripped off . I tried replacing the formula with "Left" and nothing changes either and I know it is something simple but I cannot figure out what it is, can someone help?
Thanks,
Mike
ELSEIF Contains([2nd GI],"ETA")
THEN Right(Replace([2nd GI], "ETA", ""),5)
example ETA 0526/23
Want it to be 05/26/23
