Format cells to show dates as the day of the week

[LO in Sweden]

Hello!

I need week in English now I got Swedish

I do this!

Format cells to show dates as the day of the week
Select the cells that contain dates that you want to show as the days of the
week.
On the Home tab, in the Number group, click the arrow, click More Number
Formats, and then click the Number tab.
Under Category, click Custom, and in the Type box, type dddd for the full
name of the day of the week (Monday, Tuesday, and so on), or ddd for the
abbreviated name of the day of the week (Mon, Tue, Wed, and so on).

BUT I ONY GET MÅ, TI, ON, TO, FR, LÖ, SÖ
My Regional and language Option -> Standards and forms is Swedish!
I must have Swedish so I cant change to get Mon, Tue, Wed, and so on.

Dose some one have a wokeround?

Best regards
LO in Sweden

 

[Pete_UK]

With your date in A1, you can convert that into an English day with
this:

=CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

and copy down, or you could expand the abbreviations to full names if
you wish.

Hope this helps.

Pete

 

[LO in Sweden]

Thanks Pete_UK!

You are best!


Best regards
LO in Sweden

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete