Displaying only the first two letters of the day

[King Mustard]

Type: dd/mm/yy "("ddd")";@
Shows: 01/04/18 (Sun)

However, I want "Sun" to only show "Su".

The following idea doesn't work:

Type: dd/mm/yy "("dd")";@
Shows: 01/04/18 (01)

Any ideas?

 

[James006]

Hi,

You can use following

=CHOOSE(WEEKDAY(yourdate),"Su","Mo","Tu","We","Th","Fr","Sa")

HTH

 

[JazzSP8]

If you date is in A1 then this will also work;

=LEFT(TEXT(A1,"dddd"),2)

 

[Fluff]

If you're talking about custom cell format, I'm not sure that's possible for days.

 

[King Mustard]

If you're talking about custom cell format, I'm not sure that's possible for days.

Thank you

 

[Fluff]

You're welcome