Display a date in a different language


We use the TEXT Function to convert the dates by specifying the language ID in the format argument of the formula. For example:

=TEXT("1/1/2017","[$-0809]dddd")
=Sunday

Where [$-0809] is the language ID for English, and dddd tells Excel to covert the date to the full name of the day.
The code for Dutch is [$-0413]. A complete list of codes is available here. Just replace the 4 numbers in the format with the 4 numbers of the language ID of your choice in the list (minus the 0x).