FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

The Excel Addict - Help with Excel 2013, 2010, 2007, 2003

December 17, 2015


Greetings from The Excel Addict
Hi fellow Excel Addict,

Francis Hayes (TheExcelAddict.com)Christmas is only a week away and I just want say a BIG THANK YOU for letting me share my Excel 'addiction' with you over the past year and I hope the tips I have shared have helped make things a little easier for you.

I have really enjoyed getting all those emails from my readers. Being here in a small town in Newfoundland, Canada, I think it is awesome to be able to connect with other people from all around the world who share my passion for Excel.

I also want you to know that I will be taking a short break from my newsletter to enjoy this time of the year with my family and friends. I will be publishing my next newsletter on January 12th.

At this time, I want to wish you and your family a Merry Christmas and a prosperous, safe and Happy New Year.

See you in a few weeks.

Take care and keep on Excelling,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com





If you missed my last newsletter, you can click here to view it online.


TheExcelAddict.com Quote of the Day
"Courage is not something that you already have
that makes you brave when the tough times start.
Courage is what you earn when you’ve been through the tough times
and you discover they aren’t so tough after all.”
--Malcolm Gladwell --


If you have a favourite quote, send it to me and I may post it in my newsletter.


Today's Microsoft Excel Tip

How to Show a Date and Weekday Name in the Same Cell


Sometimes with dates you may want to show the weekday name. For example, if you have a list of dates in cells B2:B12, you can show the weekday names in column A by using the formula =B2 in cell A2, copying it down and applying a custom number format using the code dddd.


Display Date As Weekday Name in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365
However, if you don't want to use two columns for your dates, you can create a custom number format to show both the date and the weekday name in the same cell.

Show Date And Weekday In Same Cell in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365
Here's how...

1) Select the cells containing your dates;

2) Click the number format dropdown on the Home tab and choose More Number Formats... (or
press CTRL+1) to open the Format Cells dialog;

Number Format Dropdown in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365
3) On the Number tab, click the Custom category and, in the Type field, click before or after the existing date format and type (dddd) and click OK. So now your dates will be something like dd-mmm-yyyy (dddd) or (dddd) dd-mmm-yyyy.

Format To Display Date And Weekday In Same Cell in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365
If you prefer, you can use the ddd format to show the weekdays as a 3-charcter text string.

Format 3 Character Weekday in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365


FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Thanks for supporting this newsletter and website


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
"Spreadsheets Tips From An Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630