E
E
Eugene Dragan2021-09-06 19:18:08
Google Sheets
Eugene Dragan, 2021-09-06 19:18:08

How to select only dates from a column?

Greetings. I import data from another document and in the column "DL by TK" there are words, for example: copyright, copywriting, restart, etc. Is it possible somehow using the formula to select only dates from this column without words.

The document with an example of the result that I want to implement is attached:
Document

Thank you in advance for your help and for the answers.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
O
Oleg, 2021-09-06
@dragan2011

Try using the formula =ISDATE() in the adjacent column

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question