Skip to content 
When working with dates in Excel, sometimes you may want to know what day the date is (whether it’s a Monday or a Tuesday, or any additional weekday).
It could especially be useful in project planning, where some days could be for a specific task (such as having a project meeting or sending the progress report), or where you need to know what days the working days are and the weekends.
In this tutorial, Excel |VBA show you a couple of ways you can use to convert dates into the day of the week and get their name in Excel.
Get the Day Name Using Custom Number Formats
One of the best methods to convert a date into the day name is by altering the format of the cell that has the date.
The good thing about this method is that while you see the day name in the cell, it continues to be the date in the back end. This way, you can still use the dates in calculations.
Imagine you have a data set, as shown below, where I have some dates in column A for which I want to know the name of the day.
Below are the steps to do this:
- Select the dates in column A
- Click the Home tab
3. In the Number group, click on the dialogue box launcher (the tilted arrow at the bottom right part of the group in the ribbon)
4 In the Format Cells dialog box, click on the Custom category option
5 In the Type field, enter “dddd”
The above steps would convert the dates in the cells in column A and give you the day’s name for those dates.
And as I mentioned, doing this would only change the way the dates are displayed in the cells, In the back end, the cells still contain the dates used in calculations.
Really enjoyed this post. Thanks Again. Really Cool. Kasey Beschorner
Hi there, always i used to check blog posts here in the early hours in the morning, for the reason that i like to learn more and more. Isaiah Sulin
You can certainly see your enthusiasm in the work you write. Leonard Hardina
Your means of explaining everything in this article is in fact fastidious, all be able to effortlessly know it, Thanks a lot. Jude Thornwell
Loving the information on this site, you have done outstanding job on the articles . Timmy Noethiger
Excellent, what a webpage it is! This blog presents valuable data to us, keep it up. Winfred Schrage
If you wish for to grow your knowledge simply keep visiting this website and be updated with the newest information posted here. Julio Ganes
Absolutely composed articles, Really enjoyed examining. Adrian Voner
As the admin of this web page is working, no question very quickly it will be famous, due to its feature contents. Von Camren
I constantly emailed this webpage post page to all my friends, because if like to read it then my links will too. Elliot Fielder
I visited many web pages however the audio feature for audio songs existing at this website is really marvelous. Kim Cernota
I always emailed this web site post page to all my associates, since iflike to read it after that my links will too. Gail Harpe
Howdy! This is kind of off topic but I need some advice from an established blog. Dorsey Hawkins
Only wanna tell that this is very useful , Thanks for taking your time to write this. Daryl Connally
Thankfulness to my father who told me concerning this webpage, this web site is truly remarkable. Ulysses Hoppe
Outstanding post, I believe people should larn a lot from this website its rattling user friendly. Mitch Passineau
Superb, what a web site it is! This web site presents helpful information to us, keep it up. Blake Moribayed
Hola vict, podrias facilitarme las familias de registro sanitario y arqueta porfa, te lo agradeciese mucho. Jarred Korb
Always a massive fan of linking to bloggers that I like but do not get a good deal of link like from. Noah Demateo
This is my first time go to see at here and i am truly happy to read all at single place. Miquel Clokey
NASCAR has declared it will ban the display of the Confederate flag at all events and on all it properties. Elmo Bivans
You made a number of good points there. I did a search on the subject matter and found mainly persons will go along with with your blog. Issac Lupkin
There is certainly a lot to find out about this subject. I really like all of the points you made. Nathanael Andoh
You completed several fine points there. I did a search on the topic and found most persons will have the same opinion with your blog. Mose Milla
Incredible points. Sound arguments. Keep up the great spirit. Scottie Levinsky
Below youll locate the link to some web-sites that we feel you must visit. Amos Hatchcock
Looking forward to reading more. Great article. Thanks Again. Fantastic. Emilio Malsam
This piece of writing gives clear idea for the new visitors of blogging, that actually how to do running a blog. Jason Lauck
I have been checking out a few of your articles and i can state pretty clever stuff. I will surely bookmark your site. Noble Lista
There is noticeably a package to find out about this. I assume you made sure nice points in attributes also. Maynard Hottle
Thanks-a-mundo for the blog post. Really looking forward to read more. Much obliged. Minh Demas
Some truly nice stuff on this web site, I enjoy it. Johnnie Bal
I cannot thank you enough for the blog article. Really looking forward to read more. King Plungy
Some truly prime content on this website, bookmarked. John Duresky
Way cool! Some very valid points! I appreciate you writing this write-up and also the rest of the site is also very good. Clark Gleber
If some one wants to be updated with newest technologies after that he must be go to see this site and be up to date all the time. Marco Varos
When planning Interior renovators New York or General development New york city, experienced professionals and proven building products are preferred. Jess Vanschoyck
Hi, after reading this remarkable paragraph i am as well delighted to share my experience here with friends. Donte Harvill
I saw a lot of website but I think this one contains something special in it. Enoch Hoffine
Great, thanks for sharing this blog. Really thank you! Cool. Junior Githens
Some genuinely great content on this website , appreciate it for contribution. Michel Drader
I loved your article post. Much thanks again. Want more. Emerson Genas
Right now it appears like Drupal is the preferred blogging platform available right now. Mohammed Damien
Like!! Great article post. Really thank you! Really Cool. Rolf Ensz