A Microsoft Excel Tutorial for Showing the Weekdays next to the Dates.

Posted on November 15, 2007
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - A Microsoft Excel Tutorial for Showing the Weekdays next to the Dates.

It’s time for another cool little Microsoft Excel Trick. If you made a list in an Excel Spreadsheet that is containing the dates it might also be very handy to have the weekdays next to them mentioned. Of course you can fill this in by hand and copy paste everything but this isn’t an option if the dates don’t follow up on each other. Here is an Excel tip to automatically generate the weekdays next to the dates and it doesn’t matter is the dates follow up.

A small tutorial for automatically generating the weekdays next to the dates in Microsoft Excel.

Create a column with dates.
Select the cells B2:B10
Type in the Excel Formula =A2
Press "Ctrl + Enter"
Then right click on the selected column
And go to the Number Tab
Then select the category Custom and type in dddd
And press OK.

Excel tip trick

Just a small side note on this Office Tip; my print screen will differ a bit from your screen. This is because my Excel is set on Dutch instead of English. The process will be the same though. I hope you enjoy this handy Microsoft Excel Trick.

Do you want to see more? This is related...

Did you ever thought about publishing your own eBook or PDF report?

Invite your friends to the World of Office.

Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!

If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.