Try using dddd for the day part of your format string e.g. dddd MMMM MM yyyy will give Wednesday December 14 2011
Answer from dazza on Stack OverflowMicrosoft Support
support.microsoft.com › en-us › office › show-dates-as-days-of-the-week-14f02f1d-8e3d-45a5-bdf8-3d962bf15327
Show dates as days of the week - Microsoft Support
Under Category, click Custom, and in the Type box, type dddd for the full name of the day of the week (Monday, Tuesday, and so on), or ddd for the abbreviated name of the day of the week (Mon, Tue, Wed, and so on). To do this task, use the TEXT function. Copy the following data to a blank worksheet.
Ablebits
ablebits.com › ablebits blog › excel › date › days of week formula in excel to get day names or numbers from date
Days of week formula in Excel to get day names or numbers from date
October 18, 2023 - In the Type field, enter the desired code for the day of week: dddd – the code for the full day names (e.g. Sunday). ddd – the code for abbreviated day names (e.g. Sun). Click OK to apply the custom format. Unlike Excel formulas, this method does not change the underlying values of the cells, but only changes how they appear in cells. In the screenshot below, you can see three columns with the same dates. Column A displays the dates in the default date format, column B shows full day names (“dddd” format), and column C shows abbreviated names (“ddd” format).
I can't find out how to get weekday from date
Format the cell with a custom format: ddd (”Mon”) or dddd (“Monday”). Or you can add it to the existing format: DDD DD.MM.YYYY (“Mon 01.01.2001”) Here’s a link with more info: https://www.excelcampus.com/functions/get-week-day-name-of-date/ More on reddit.com
35
22
October 23, 2021excel : format dates so that they include the day of the week in full letters - Stack Overflow
In excel 2007, how can I format my dates so that they include the day of the week in full letters ? I've tried typing around but I just can't guess it. More on stackoverflow.com
convert date to the day of the week
=TEXT(DATEVALUE(TEXTJOIN("-",, [@DAY], [@MONTH], YEAR(TODAY()))), "dddd") "January" is not a number, you can't just add it to a day number or a year. More on reddit.com
8
2
December 18, 2024Displaying numbers (not dates) as days of week, with 1=Monday
https://support.microsoft.com/en-us/office/weekday-function-60e44483-2ed1-439f-8bd0-e404c190949a Return type 2 More on reddit.com
6
1
November 20, 2023Videos
02:25
Get the Day of Week from a Date 📅 in Excel - YouTube
Use Excel to Convert Date to Day of Week Using WEEKDAY - YouTube
01:01
How to Convert Excel Date to Day of the Week - YouTube
00:56
How to Format Date to be a Day of the Week in Microsoft Excel! ...
02:48
Microsoft Excel - Using the TEXT function to identify a day of ...
00:16
Excel tip to get day of the week from a date - YouTube
Microsoft Support
support.microsoft.com › en-us › office › weekday-function-60e44483-2ed1-439f-8bd0-e404c190949a
WEEKDAY function - Microsoft Support
Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.
Excel Insider
excelinsider.com › home › our blog › excel pro tips › how to display day of week from date in excel (4 easy ways)
How to Display Day of Week from Date in Excel (4 Easy Ways) - Excel Insider
June 18, 2025 - In that case, your formula should follow this format: =TEXT(A2, “dddd, mmm dd, yyyy”). Here, the dddd is for displaying the day, mmm for the month, dd for the date, yyyy for the year.
Ablebits
ablebits.com › ablebits blog › excel › date › weekday formula in excel to get day of week, weekends and workdays
WEEKDAY formula in Excel to get day of week, weekends and workdays
October 10, 2023 - The result is an integer, ranging from 1 (Sunday) to 7 (Saturday) by default. If your business logic requires a different enumeration, you can configure the formula to start counting with any other day of week. The WEEKDAY function is available in all versions of Excel 365 through 2000. ... Serial_number (required) - the date that you want to convert to the weekday number.
Reddit
reddit.com › r/excel › i can't find out how to get weekday from date
r/excel on Reddit: I can't find out how to get weekday from date
October 23, 2021 -
Hello everyone. I wanted to create a spreadsheet in Excel, and I've barely used it before. Something I haven't managed to do is to extract the weekday from a date. This sounds fairly simple, but I just can't wrap my head around it and can't find much to help. Sorry if this is a stupid question.
The format is DD.MM.YYYY
Top answer 1 of 5
15
Format the cell with a custom format: ddd (”Mon”) or dddd (“Monday”). Or you can add it to the existing format: DDD DD.MM.YYYY (“Mon 01.01.2001”) Here’s a link with more info: https://www.excelcampus.com/functions/get-week-day-name-of-date/
2 of 5
10
If your date is in A1 the formula to get day of week is =TEXT(A1, “dddd”). Or use 3 d’s if you want shorter day name.
Indeed
indeed.com › career guide › career development › how to get the day of the week from the date in excel
How To Get the Day of the Week From the Date in Excel | Indeed.com
June 28, 2024 - After calculating the WEEKDAY function, you can use the steps below to convert dates into days with the CHOOSE function: Identify where your WEEKDAY function originates (A2 for this example).
ExcelDemy
exceldemy.com › home › excel basics › how to display day of week from date in excel (8 ways)
How to Display Day of Week from Date in Excel (8 Ways) - ExcelDemy
June 28, 2024 - Insert the following formula in the formula box. =CHOOSE(WEEKDAY(B5),"Sun","Mon","Tue","Wed","Thu","Fri","Sat") Press Enter to apply this formula. Drag the Fill Handle icon or double-click on the icon to apply this down the column.
ExtendOffice
extendoffice.com › documents › excel › 4 easy ways on finding day of week from any date
4 easy ways on finding day of week from any date
December 11, 2024 - The Format Cells feature of Excel allows you to modify the dates to various formats including day of the week. Under Number tab, select Custom, then go to the Typesection, enter ddddinto the textbox. Click OK. Note: If you want to show the dates as weekday in abbreviation, such as "Mon", in ...
The Bricks
thebricks.com › resources › how-to-get-day-of-week-from-date-in-excel
How to Get the Day of the Week from a Date in Excel
Select "Custom" from the "Category" list on the left. In the "Type" input box, you’ll enter a specific format code. Here’s what they mean: ddd: Displays the abbreviated day of the week (e.g., "Mon", "Tue").
Excel Easy
excel-easy.com › examples › weekdays.html
Weekday Formulas in Excel - Step by Step Tutorial
The WEEKDAY function in Excel returns a number from 1 (Sunday) to 7 (Saturday) representing the day of the week of a date. 1. The WEEKDAY function below returns 2. 12/22/2025 falls on a Monday.
Unstop
unstop.com › home › blog › weekday formula in excel | determining day of the week from date
WEEKDAY Formula In Excel | Determining Day Of The Week From Date
February 5, 2025 - The WEEKDAY function defaults to Sunday as the first day of the week (return_type = 1). Adjust this for other calendars. Ensure formulas align with the context of your data. For instance, highlight weekends only if they are relevant to your analysis. For recurring tasks, automate processes with formulas combining WEEKDAY and IF. The WEEKDAY function is a powerful ally for managing dates in Excel.
Excel Campus
excelcampus.com › home › tutorials (blog) › 3 ways to get the day name for a date
3 Ways to Get the Day Name for a Date - Excel Campus
April 10, 2016 - · The keyboard shortcut for the Format Cells Window is: Ctrl+1 · Click on the Long Date format and the Sample box will show a preview that includes the day of the week. You can also apply a Custom number format to just display the weekday ...
Exceljet
exceljet.net › get day name from date
Get day name from date - Excel formula | Exceljet
May 14, 2024 - To get the day name (i.e. Monday, Tuesday,Wednesday, etc.) from a date, you can use the TEXT function. In the example shown, the formula in cell C5 is: =TEXT(B5,"dddd") With January 1, 2000, in cell B5, the TEXT function returns the text string ...
Structured Analytic
blog.tedjordan.org › home › weekday
Excel: convert a date to day of the week - Ted Jordan
January 14, 2026 - If you want to show the name of the day (in an abbreviated form) from a date, use this formula: =TEXT(date,”ddd”). In this example, we want to know the day of 31/10/2023 selecting the cell containing the date.
How-To Geek
howtogeek.com › home › microsoft › how to find the day of the week from a date in microsoft excel
How to Find the Day of the Week From a Date in Microsoft Excel
December 31, 2021 - Then select the cell in which you want to display the day of week. In the selected cell, type the following TEXT function and press Enter. In this function, replace B2 with the cell where your date is.
Top answer 1 of 10
55
Simple example:
A1 cell: 1/8/2009
B1 cell: =TEXT(WEEKDAY(A1),"dddd")
This will, for the given date, print the corresponding day.
Is this what you wished ?
2 of 10
20
The answer given above is only working by fluke because Excel thinks that 1/1/1900 was a Sunday* and by default Excel is using Sunday as first day of week for the Weekday function.
What you are actually calculating in that method is the day of the week as a number, then formatting that as a day based on that number interpreted as a date. Eg if your date is 1/2/2003 and you use the WEEKDAY function, this results in 7 (=Saturday). When you then format this as "dddd" you are actually getting the day name of the 7th day in Excel since its "epoch", ie 7/1/1900, which happens to be a Saturday*. This formula will break if someone opens it who has the option selected to use the 1904-based date system, as 1/1/1904 was not a Sunday, but a Friday. (yes I know hardly anyone uses that, but you don't want to build a solution which relies on that do you?)
You can make the formula shorter, faster and more robust simply by using
=TEXT(A1,"dddd")
You could of course just format the date cells themselves with a custom format as already suggested, depending on whether you really need this in a separate column or not. I often use date formats such as
ddd dd mmm yyyy
to give eg Sat 01 Feb 2003 so the date is explicit but shows the weekday name as well.
Using a second column and a TEXT function is essential if you want to use the weekday explicitly somewhere in a mail merge (for example), similarly for things like currencies and so on Excel > Word merging passes the actual underlying stored value rather than the on-screen formatted version, so regardless of the cell format, Word sees some horrible number. A true text field is passed 'as is' and displays properly in Word.
*in fact it is a Monday but Excel was written to match the incorrect dates in Lotus 1-2-3 which treated 1900 as a leap year when it is not.
Quora
quora.com › How-do-you-extract-the-day-of-the-week-from-a-date-in-Excel
How to extract the day of the week from a date in Excel - Quora
Answer (1 of 3): TEXT Function in Excel can be used to return the corresponding Weekday, Month or Year from an Excel Date. The following formula will return Thursday, the weekday corresponding to the date 25/06/2020 [code]=TEXT("25/06/2020","DDDD") ...
TeachExcel
teachexcel.com › excel-tutorial › 1886 › format-a-date-to-show-only-the-day-of-week-in-excel
Format a Date to Show Only the Day of Week in Excel - TeachExcel.com
How to format a Date so that only the day of the week is visible from that date Result Steps Right click the desired cell and click Format Cells Go to the Number tab and click the Custom category Unde ...