I have this formula in Cell AL13 and it is used to translate text into date
format from a mainframe. I tried other methods by formatting the cell into
text, general, etcc... and it's frustrating, so I came across this formula
below and it works great.

=DATE(RIGHT(AK13,4),LEFT(AK13,IF(LEN(AK13) = 8,2,1)),LEFT(RIGHT(AK13,6),2))

The problem is when there is no data to work on the cell displays #VALUE!.

How can I get rid of #VALUE! from being displayed?

I did try working on the next column Cell AM13 with this formula and I get
the same #VALUE! on the screen.

=IF(AL13="","",AL13)

Thank you!