Display single letter Day of week in Excel

Is it achievable?  Not by formatting but formula.

Excel Tips - Single Letter Day of Week 1

Did you know that you may format a date to display the month portion of it into various formats shown below?Excel Tips - Single Letter Day of Week 5

I think most people know the first fours (M to MMMM) but the fifth one (MMMMM, i.e. M x 5).  And now, we all know it! 🙂

Excel Tips - Single Letter Day of Week 4

I follow the same logic and apply the “DDDDD” format to display the day portion of a date, hoping that it will return a single letter Day of week…… without success. 😦Excel Tips - Single Letter Day of Week 6.png

Honestly, I don’t know why there is such a difference in formatting between Month and Day:

Excel Tips - Single Letter Day of Week 2

But life has to continue and I have to find another way to achieve what I need… Excel Tips - Single Letter Day of Week 1

A simple formula saves my day

Excel Tips - Single Letter Day of Week 3

=LEFT(TEXT(date,"DDD"))

Yeah.  As simple as that.  Hope this post will save your day too. 🙂

=====================================================

Just a quick reminder that the awesome Excel Dashboard Course, by Mynda Treacy will be closing on Thursday May 26, 8pm in Los Angeles, to be exact. You may watch the FREE webinar first if you are not sure what an Excel Dashboard is.

Free Excel Dashboard Webinar

Disclosure: I make a small commission for students who join Mynda’s course via my site, but as you know I don’t just recommend anything and everything. It has to be of outstanding quality and value, and something I can genuinely recommend. After all, if doesn’t live up to what I’ve promised you’ll think poorly of me too and I don’t want that. Oh, and just watching the course videos won’t transform your career, like you won’t become a Master Chef by reading cook book only.  You have to actually put it into practice, but then you know that.

This entry was posted in Format, Formula and tagged , , , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s