Microsoft Excel 'Quick Tip'
Previously published in my "Spreadsheet Tips From An Excel Addict" newsletter

Get The Day Of The Week From A Date

Let's say you have a date 22-Sep-08 in cell A1 and you want to determine the day of the week.

The formula =WEEKDAY(A1) will return 2 (the 2nd day of the week). This would be useful if you want to do calculations based on the day of the week.

If you'd like to return the name of the weekday, use this formula:

WEEKDAY(A1) will evaluate to 2, and CHOOSE will find the 2nd item in the list.

You can also use the TEXT function to get the name of the weekday from a date.

Assuming that the date in cell A1 is 22-Sep-08. In another cell, enter =TEXT(A1,"ddd") and you will get "Fri". If you enter =TEXT(A1,"dddd") you will get "Monday"

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright All Rights Reserved by fhayes(AT)TheExcelAddict(DOT)com

Close this window