Hi all,
I'm trying to provide the ability for a user to select a language from a drop-down cell and have a different cell value change accordingly. This formula works:
=TEXT(A1,"[$-406]dddd") and turns Thursday into Torsdag (Danish) very nicely.
What I'd like to do is have the [$-406] part of...