0

I am using the TEXT function like =TEXT(B1, "ddd") where B1 is formated as date to display the weekday. This works fine on an english regional system.

On a machine with a german regional setting the formula doesn't work because the format literal must be "ttt". So on a german system the formula would have to be =TEXT(B1, "ttt")

How can that same spreadsheet be used on a system with an English regional setting and on another machine with a German regional setting?

Raystafarian
  • 21,963
  • 12
  • 64
  • 91
Christian
  • 103

1 Answers1

1

This won't let you use the value in later calculations, but it's a reasonable work-around for the problem you face - 

=CHOOSE(WEEKDAY(B1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
Raystafarian
  • 21,963
  • 12
  • 64
  • 91