Hello, I try to create a drop-down list dependent of a cell range with date contents, but when I open my list, contents show as numbers, however when I choose one of them, sit correct date format in the cell. do you have a solution?
How did you create the list? Using Data Validity, or as Form Control Listbox with Data source? Anyhow, both variants for me display formatted dates if the source range contains dates. Validity in the format applied to the cell range, and the Listbox control in the default date format. For the Listbox control the linked target cell needs to be formatted as date.
Hi dear erAck 
I used of Data validity, and yeah, I understood that when I use of data source directly in the cell range, calc is able to apply date format in the dropdown, but when I use of a condition to choosing goal dates as my range, result in the dropdown shown like integer numbers. I found that it is fixable with TEXT() function, but it takes a long time to show the result.
If i understand your question, try to format the cells, Ctrl+1/numbers.