Is it achievable? Not by formatting but formula.
Did you know that you may format a date to display the month portion of it into various formats shown below?
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! 🙂
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. 😦
Honestly, I don’t know why there is such a difference in formatting between Month and Day:
But life has to continue and I have to find another way to achieve what I need…
A simple formula saves my day
=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.
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.
wmfexcel 