Answer the question
In order to leave comments, you need to log in
How to convert datetime value to date???
Let's say there is a date and time value: "2018-08-09T17:22:35Z".
When entering it into a google spreadsheet cell, I want to convert it to a date format (DD.MM).
That is, like this: 2018-08-09T17:22:35Z => 09.08 (or something like this)
How to do this???
ps formula =TEXT(2018-08-09T17:22:35Z,"DD.MM") doesn't help. Throws out an error.
Answer the question
In order to leave comments, you need to log in
=TEXT(REGEXEXTRACT("2018-08-09T17:22:35Z";"..........");"DD.MM")
It seems to work. Not too primitive?)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question