2-letter DAY format

[zest1]

Anyone know how to format a date cell to display only a 2-letter day abbreviation (ie. Mo, Tu, We, Th, Fr, Sa, Su)? dd gives the day "number", rather than text.

Thanks

[matthewspatrick]

I do not think it can be done with number formatting. I would try using another column to show it:

=INDEX({"Su";"Mo";"Tu";"We";"Th";"Fr";"Sa"},WEEKDAY(F1))

Or:

=LEFT(TEXT(F1,"ddd"),2)

[zest1]

Thanks Patrick!

That's just what I needed. I also played around with 'WEEKDAY' and 'TEXT' alone but of course woudn't work without 'INDEX' and your formula.

Thanks again.

[matthewspatrick]

You're welcome. You may want to use the formula I gave without the INDEX--it's shorter.

[zest1]

I realize why 'TEXT' wasn't working for me - I left out the " "'s marks.

thanks again for your help Patrick.