M
M
madentixx2022-04-03 23:07:46
Google Sheets
madentixx, 2022-04-03 23:07:46

How can I make data validation only capture certain data from one cell?

I need to make data validation output results based only on the date in the cell (dd.mm.yyyy), but not take into account the time after the date in the same cell [dd.mm.yyy hh:mm:ss]

then yes, conditionally, I need to display several items with the same date, not taking into account the time, and accordingly, so that the filter function also reacts only to the date in the cell, but at the same time displays it in full, that is, with the date and time

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
dollar, 2022-04-04
@madentixx

The simplest is to make the second column for the date, where each cell refers to the full date and discards the fractional part (like a number).

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question