Calculate the Day of the Week in Excel

You've just entered a bunch of dates into your Excel spreadsheet, but what you really want to see is what day of week those dates happen on. Fortunately, Excel makes it easy to calculate the day of week with a simple formula. With a bit of handiwork, you can get the abbreviated or full weekday name. You'll just have to know the appropriate excel shortcut: =TEXT((A1), "ddd")

Steps

1. Enter a date reference in a cell. For this example, we'll use the date "11/7/2012." In A1, enter that date.
2. Calculate the abbreviated weekday name. In cell B1, enter =TEXT((A1), "ddd") into the cell or formula field.
   • The "ddd" setting tells Excel to use the first three letters of the weekday name. In this example, "ddd" becomes "Wed".
3. Calculate the full weekday name. In cell C1, enter =TEXT((A1), "dddd").
   • This will calculate the full weekday name.
   • To add additional date info, use the following conventions, in any order:
     • Time: hh:mm:ss will give you the full time. You can also enter any part of that for more abbreviated time displays.
     • Day of week: as described above, ddd gives you the abbreviated day name, and dddd gives you the full day name.
     • Date: dd will give you the date with a leading zero for the 1st through the 9th. A single d will drop the leading zero.
     • Month: mmm will give you the abbreviated month, and mmmm will give you the month spelled out.
     • Year: For just the decade, use yy. For the complete year, use yyyy.
   • For example, to have field A1 (as above) read as "Wed, 7 Nov., 2012" you would enter "=TEXT((A1), "ddd, d mmm., yyyy"). Make sure you include the quotes, and that your parentheses are balanced (as many open ones as closed ones).

Tips

• Rather than typing in a cell reference (such as A1, above, to reference the date cell), you can simply click on that cell after typing "=TEXT("
• Rather than write a formula, you can just format the cell containing the date as follows:

Things You'll Need

• Microsoft office package(excel sheet)
• Desktop or phone using excel
• Microsoft excel knowledge

Related Articles

• Convert Measurements Easily in Microsoft Excel
• Create a Currency Converter With Microsoft Excel
• Create a Mortgage Calculator With Microsoft Excel
• Apply Conditional Formatting in Excel
• Sort Microsoft Excel Columns Alphabetically

See also

• Create a Sin and Cos Circle in Excel
• Add a Header or Footer in Excel 2007
• Calculate CAGR in Excel
• Use Excel for Your Finances
• Parse Data in Excel
• Create Custom Lists in Excel
• Remove Leading or Trailing Zeros in Excel
• Remove Spaces Between Characters and Numbers in Excel
• Use Vlookup With an Excel Spreadsheet
• Create a User Defined Function in Microsoft Excel

Read more ...

What links here

• Create Pivot Tables in Excel
• Group and Outline Excel Data
• Create a Mortgage Calculator With Microsoft Excel
• Create a Histogram in Excel
• Create a Calendar in Microsoft Excel
• Add Images in Excel
• Add Two Cells Already Containing Sum of Other Formulas
• Alphabetize Cells in Excel
• Calculate the Day of the Week
• Calculate the List Price of an Item on Sale

Read more ...