Is there a simple way to add multiple characters into a set of strings of consistent length/format?

Basically I have a list of dates formatted as, for example, 20220223 (2022 being the year, 02 the month, 23 the day). I want to write a script that just adds in slashes to change this from a number to something that excel would recognize as a date, eg 2022/02/23, but all the answers I've found about how to do this seem to focus on inserting just a single character into a string and I'm not sure how to adapt it for multiple characters.

Basically all I would need is a way to insert a slash after the first four characters, and then another one after two more characters. With that I should be able to loop through the list and repeat it for each date easily enough. Thanks in advance for any help.

EDIT: Forgot to include initially but this is for VBA in Excel.