PDA

View Full Version : 2-letter DAY format



zest1
03-10-2006, 11:02 AM
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
03-10-2006, 11:15 AM
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
03-10-2006, 11:25 AM
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
03-10-2006, 11:26 AM
You're welcome. You may want to use the formula I gave without the INDEX--it's shorter.

zest1
03-10-2006, 11:34 AM
I realize why 'TEXT' wasn't working for me - I left out the " "'s marks.

thanks again for your help Patrick. :)