How to Convert Text to Date in Google Sheets

In this video, I show how to convert text to date in Google Sheets. I will show two ways of doing this. The first works when your dates are entered as text format by using a combination of the TO_DATE and DATE_VALUE functions. The second method works when your date is in an 8 digit format by extracting out the year, month, and date and converting it with the DATE function.

Read through the full tutorial here:

[sarikasharma]

This video helps me to resolve one issue at my work place....Thank you so much...

[seaningham]

My issue is the date appears as August 3rd, 2024. How do I convert it to 08/3/2024?

[zzprod]

how do I do the opposite? I need to convert a date into a plain text yymmdd without the date string attached to it (without the date information).

[reginaldespina]

how about mm/dd/yyyy hh:mm (text format to date format?

[iammichaelhughes]

How do you work with this text data and get it converted to a numeric date value: January 3rd 2023 9:06:23 am

[MaryPAULINElove]

I didn't get the timestamp from 2:17