

You want to know the weekday of a certain date? Excel provides the WEEKDAY formula. The formula returns the day of the week as a number, for example 1 for Sunday, 2 for Monday and so on. You can further modify, which weekday should start with the number one.
Contents
The WEEKDAY formula has 2 arguments (the numbers are referring to the picture on the right hand side/above):
The help function of Excel provides the following table. The first column shows the numbers available as the return type (number two in the picture). The second column describes the system:
Return_type | Number returned |
1 or omitted | Numbers 1 (Sunday) through 7 (Saturday). Behaves like previous versions of Microsoft Excel. |
2 | Numbers 1 (Monday) through 7 (Sunday). |
3 | Numbers 0 (Monday) through 6 (Sunday). |
11 | Numbers 1 (Monday) through 7 (Sunday). |
12 | Numbers 1 (Tuesday) through 7 (Monday). |
13 | Numbers 1 (Wednesday) through 7 (Tuesday). |
14 | Numbers 1 (Thursday) through 7 (Wednesday). |
15 | Numbers 1 (Friday) through 7 (Thursday). |
16 | Numbers 1 (Saturday) through 7 (Friday). |
17 | Numbers 1 (Sunday) through 7 (Saturday). |
Example 1: The weekday number for the US system (Sunday = 1)
=WEEKDAY(A1)
Example 2: The weekday number for the European system (Monday = 1)
=WEEKDAY(A1,2)
Hold on a second. Was this information helpful so far?
Why don't you subscribe to our monthly, free Excel newsletter?
Subscribe now! Your welcome gift: Our big 45 pages keyboard shortcuts package. In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Of course, I'm also on other networks:
Twitter: Follow @professorexcel
Facebook:
In many cases, you don’t want to deal with numbers but rather the names of the weekdays (see number 3 in the image above). A simple VLOOKUP should help converting the number to a name. Therefore, you have to prepare a lookup table as shown in number (4): The numbers 1 to 7 in one column and the corresponding names in the next column. So the VLOOKUP formula could look something like this:
=VLOOKUP(‘your date’,F:G,2,FALSE)
Get the weekday name from any date given in another cell.
If you want to get the weekday name of the date, given in another cell, please copy and paste this formula. Instead of “A1” within the WEEKDAY formula, just refer to the cell you like.
=CHOOSE(WEEKDAY(A1),”Sunday”,”Monday”,”Tuesday”,”Wednesday”,”Thursday”,”Friday”,”Saturday”)
If you want to get todays weekday, just copy and paste this formula:
=CHOOSE(WEEKDAY(TODAY()),”Sunday”,”Monday”,”Tuesday”,”Wednesday”,”Thursday”,”Friday”,”Saturday”)
Get the WEEKDAY name with this formula.
The first part of the formula (WEEKDAY(TODAY())) returns the number of the current weekday. The corresponding name of the day will be returned from the second part. Please refer to this article for some explanation about the TODAY formula.
Our Excel add-in “Professor Excel Tools” comes with a useful formula: If you type =PROFEXWeekdayName() into a cell and link to a date (or provide a date within the brackets), it’ll return the name of the weekday. It can be that simple. Try it for free with the download button below.
This function is included in our Excel Add-In 'Professor Excel Tools'
Learn more Download Free Trial
(No sign-up, download starts directly)
More than 10k people on Facebook can't be wrong.
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.