Convert ISO date string to date in Google Sheets | #Short

In this tip, We are going to explore:
Convert ISO date string to date in Google Sheets.
All explanations are simple and to the point.

#Shorts #GoogleForEducation #GoogleWorkspace #GoogleSheets

Feel free to make your copy of this spreadsheet (Sheet 02):
https://docs.google.com/spreadsheets/d/13ze8jEgIQ2yRMown8aGXyARLe_zEZL01CSBVBEFFL2A/copy
If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded

Useful Link:
Google Workspace Tutorial:
https://www.youtube.com/c/GoogleWorkspaceTutorial

Ben Collins (Google Developer Expert & Data Analytics Instructor)
https://www.benlcollins.com/

Google Sheets training:
https://support.google.com/a/users/answer/9282959

The Playlist link:
https://youtube.com/playlist?list=PLyZklaIlJ-rfPStL6Zb34K5Ce0dKbkzos

Follow us on Pinterest:
https://www.pinterest.it/GoogleWorkspaceTutorial/_created/

The tip inspired from:
https://stackoverflow.com/questions/30492832/iso-8601-string-to-date-in-google-sheets-cell
Here is an ISO date String.
If we use the DATEVALUE to convert it, it returns an error.
First, we need to split the string.
We use the SPLIT function.
SPLIT(A1,"TZ")
We use the SUM function to join these values.
SUM(SPLIT(A1,"TZ"))
By using this formula, we covert the ISO string to a date and time value.

Видео Convert ISO date string to date in Google Sheets | #Short канала Google Workspace Tutorial