A
A
Andrey PINEAPPLE2018-08-09 21:43:10
Spreadsheets
Andrey PINEAPPLE, 2018-08-09 21:43:10

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

2 answer(s)
A
Aleksandr, 2018-08-09
@AndreyHudz90

Regular expression and corresponding Google Sheets function.

A
Andrey PINEAPPLE, 2018-08-09
@AndreyHudz90

=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 question

Ask a Question

731 491 924 answers to any question