December 17, 2015
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)
If you missed my last newsletter, you can click here to view it online.
If you have a favourite quote, send it to me and I may post it in my newsletter.
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.
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.
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;
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.
If you prefer, you can use the ddd format to show the weekdays as a 3-charcter text string.
|"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