How to Convert from a YYYYMMDD to a Date
In this video I demonstrate how to easily convert your string/text date from a YYYYMDD to an Actual Date.
Aside learning how to do this, you will also be learning additional knowledge on how excel works.
Enjoy!
Download the sample file used in the video here:
https://docs.google.com/spreadsheets/...
----Timecodes --
0:00 – Intro
0:51- Extracting date components with functions
0:54 - Extracting the year using LEFT function
2:35 - Extracting the month using MID function
4:32 - Extracting the day using RIGHT function
5:02 - Combining components using the DATE function
6:51 - Writing a single nested formula
7:25 - Step-by-step nested date formula walkthrough
8:46 - Final remarks
---------------------