Assuming the date is numeric, something like:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

HTH

"JIM.H." wrote:

Hello,
How can I convert the date with the format YYYYMMDD to MM/DD/YYYY with a
formula?
Thanks,