formula for data validation

[xam99]

Hi tio all.
In the attached workbook

if ingl put the cells in English column S in column U
if ita put the cells in Italian column S in column U

thanks you
xam

[Bo_Ry]

Please try at U2

=TEXT(INDEX($S$2:$S$13,ROWS(U$2:U2)*2-($T$2="ita")),"[$-"&IF($T$2="ita","it","en")&"]dddd-mmmm-yyyy")

[xam99]

Hi bo_ry, thank you.
The date is not correct
Now is is dddd-February-yyyy

[Bo_Ry]

This works in English Excel.

I don't know Italian, maybe try

=TEXT(INDEX($S$2:$S$13,ROWS(U$2:U6)*2-($T$2="ita")),"[$-"&IF($T$2="ita","it","en")&"]gggg-mmmm-aaaa")

1.jpg

[xam99]

Why the formula doesn't it copy the same format as the date column S in column U?

[xam99]

Hello the correct date with formula is not working.
it is possible with a private change macro

if T2 = ing U2 = W6
if T2 = ita U2 = V6

[xam99]

The macro does not report in U6 the same text as V6 or W6

Please Login or Register  to view this content.

[AliGW]

Shall I move this to the VBA section for you?

[xam99]

Hi aligw, o.k.

[xam99]

I don't understand where I'm wrong

Please Login or Register  to view this content.

in U6 the values / text of V6 or W6 do not come out