CODEWITHSUNDEEP
excelexcel-formula
eliasmaxil
eliasmaxil

Reputation: 558

Convert long date format in text for non english language in excel

I have a cell with the current date Dutch using =today() in long format. So my result is 'dinsdag 01 januari' (without the quotes) and I want to retrieve the word 'dinsdag' (Tuesday) for further comparison. But as the formula =today gives a number, I need to force a conversion of the date into text. I have tried with =text(today(),"dddd") but the result is the string Tuesday (in English) so it gives a different result.

Is there a method to convert the date using =today() in another language into text to get the string 'dinsdag' instead of 'Tuesday'? Thanks

Upvotes: 0

Views: 437

Answers (2)

Scott Craner
Scott Craner

Reputation: 152465

Use this:

=TEXT(TODAY(),"[$-413]dddd")

The [$-413] is the hexadecimal code for Dutch. See HERE for full list.

enter image description here

Upvotes: 1

teylyn
teylyn

Reputation: 35915

The formula is a good start. Use it inside a lookup table with two columns: English and Dutch

=vlookup(text(today(),"dddd"),Sheet1!$a$2:$b$8,2,false)

enter image description here

Upvotes: 1

Related Questions