Converting an 8 digit number to a Date in Google Sheets

Learn how to use Regex to create a formatted date out of an unformatted 8 digit string with no delimiters. 20240826 to 26/08/2024 or 08/26/2024.