Get the Day of the Week from a Date in Microsoft Excel 2007?

How to Get the Day of the Week from a Date?

Column A here has dates as MM/DD/YYYY.

On the top left side of Column A, right click and select “Insert” to add a new column before Column A.

Once added, add a header in A:1 and name it “Date of the Week”.

Then in the cell A:2 type in the following formula:

=CHOOSE(WEEKDAY(B2),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

Explanation: This formula will use the WEEKDAY() Function to replace any date with a number which will equal your weekday. For example if you simply type in WEEKYDAY(B2), it will output 3. We want to convert 3 into a weekday, and this is why we force that function to replace 3 with Tue.

Press ENTER and you will see Tue in A:2.

If you have multiple dates you would like to convert, simple select the cell on the lower right section and drag down your formula to apply this on all your worksheet in column A.

Done:




For more Microsoft Excel 2007 tutorials

Follow us on Twitter
Subscribe to our Feeds 		Become a Fan on Facebook
Added Sunday, January 9th, 2011. Category Microsoft Excel 2007 Keywords

Add your comment



New Tutorials in your inbox!






Most Popular Category Today

Think Tutorial is a database of simple, easy to follow tutorials covering all aspects of popular computing. Technology is fantastic, but it can be difficult to keep up with at times. Think Tutorial's strength and success resides in its very intuitive approach and design that keeps everything simple and organized.

Statistics

TUTORIALS PUBLISHED
1,442

EQUATES TO
+3700 minutes
or
+62 hours of continuous education.

USERS ONLINE
396

AWESOME FACEBOOK FANS
5449

Why Free?

Free, easy, useful and straight-to-the-point stuff? That's what people want!

Follow Us

RSS Subscribe to Feeds
facebook Be a fan on Facebook
twitter Follow us on Twitter


© 2010-2012 Prestance, Inc. All right reserved.
All Trademarks and Brands displayed on ThinkTutorial are the sole property of their respective owners/creators and All third party trademarks are the exclusive property of the respective companies and their use does not indicate endorsement.