Convert ISO date string to date in Google Sheets |
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/...
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:
/ googleworkspacetutorial
Ben Collins (Google Developer Expert & Data Analytics Instructor)
https://www.benlcollins.com/
Google Sheets training:
https://support.google.com/a/users/an...
The Playlist link:
• The most useful Google Apps Tips and ...
Follow us on Pinterest:
https://www.pinterest.it/GoogleWorksp...
The tip inspired from:
https://stackoverflow.com/questions/3...
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.
