Data validation error

read big yellow banner at the top of this page HOW TO ATTACH excel file properly

btw. type =TODAY() in any cell (not manually formatted) and see the format generated by Excel

I've read it, I I'm aware how to post an file, but I can't post the file with the data validation condition, because if it has an error and I can't save the file, so the error can't be seen. Sorry, if I'm doing something wrong, I'm a noob in Excel. Tks for the TODAY suggestion

Update and question...
If I have another question about data validation, but with different condition, do I have to open another thread?

tested and it works

dvdate.png

dvdate2.png

DV works if you manually enter value, date or number etc. but if you will use copy/paste it doesn't work properly

Ok, but if I want the data to be formatted as 01.01.1900 how can I do this, because my Excel generate the date as 20,11,2022... As I insert the data, I want to insert the data with a dot, not with comma or slash...

see your format of dates

formatcell.png

also select your A2 cell and resize to bigger than now , if your date is aligned to the left it means this is not a proper date but text
you can try with selected A2 and change format to General, if you see number it will be a date if you still see "date" - this is a text not a date

I'm sorry if I don't express myself correctly, to make myself understood... so, the regional settings are of the type date dd.mm.yyyy, with the dot...
Screenshot 2022-11-20 145427.jpg
My cell is formatted as custom like [$-ro-RO ]dd.mm.yyyy. but, if I want to enter the date from the keyboard like 01.01.1900, the validation condition does not work.
Screenshot 2022-11-20 150010.jpg
I don't want every time I enter the date, to have to enter it with a comma.
Screenshot 2022-11-20 135706.jpg



Sorry if the images are to big, I did not know how to resize it!

If I have another question about data validation, but with different condition, do I have to open another thread?

if it will be the same problem you can continue here

as I can see your dates in the cells are TEXT
romania.png

in Format Cells check date format not in Custom but in Date (see post#8)

Custom format is What You See not What You Really Have
dates.png


desc.png

Ok, I understood. Tks a lot for your help.

P.S. Sorry for the Book1.xlsx file, it was wrong...

P.S2. My second problem is about data validation by list from external source... can I insert an condition on data validation as list, but the source to be another workbook than the original? Because I've tried, but it can't work... How I can do this?

DV doesn't accept direct reference to another workbook, but you can create a list in another worksheet and use it after hiding this worksheet, but maybe I'm wrong and someone else will give a better solution, I am Power Query user

you can define Name for your list and use it everywhere in the workbook

listname.png

or with Power Query you can import list from another workbook, load to the sheet and use it as normal list in DV

in the book is "it's possible" and that's all?

you can try with INDIRECT() but workbook with list must be open
try here
Drop Down List from Another Workbook

No, it is not all... the book says this:

Step 1. Open workbook „balkaniada” with FileOpen.
Step 2. We configure the Excel window so that both registers are opened simultaneously through Windows Arrange.
Step 3. We position ourselves in the spreadsheet where we have the "Competition_discipline" field. We check that the values ​​we will use for the validation list are constituted in an Excel list.
Step 4. Through Insert Name Define we will give the name "discipline", and in the editing area Refers to... we delete the existing reference and by outlining with the mouse we enter the references of the discipline_de_concurs column from the "inspected" register which is active!
Step 5. In the Define Name window we add the new name.
Step 6. We select the "balkaniada" register and position ourselves on the cell where we want to insert the validation through the (drop-down) list.
Step 7. We open the Data Validation validation window, enter the name of the domain (created as an external reference!) preceded by the = sign. See the attached screenshot.
Careful! Let's not forget that the "inspected" register must be open when editing the "participants" database!
This are the pictures...
Picture2.png

What you suggested seems to be the same as my book, but doesn't work...

I can suggest nothing because I prefer life easier not harder

btw. your attachment doesn't work = incorrect attachment

I did what she said in the link from above and it working as hell !

dvs.png

Both workbooks MUST be open !

and use View - Zoom - 100% picture should be smaller