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. :)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.