How to Obtain Weekday Name from a Date in Excel (3 Easiest Ways)
A free Office suite fully compatible with Microsoft Office
A free Office suite fully compatible with Microsoft Office
Excel is powerful spreadsheet software that is used for data analysis and management. Excel is a great tool, mainly because it has so many different functions that can be used to manipulate your data. But the best part is that you can use Excel spreadsheets to create automated processes. One of the most common tasks that people perform using Excel is the creation of a report that shows the day names for each week. This is commonly seen in some companies where employees take turns in reporting for example on Fridays.
For that, we need to extract weekday names from a data set because we want to present weekdays in the excel dashboard., This article will provide you with an efficient way to obtain weekday names from a data set in an excel sheet for making various calculations on them.
How to get a weekday name in excel from a date: Formatting method
Formatting method involves the use of different date formats and converting them back to the day of the week, there are many different formats available when it comes to writing what date it is , we can make our own custom one and convert it into the day
Select the cell having date input
Left-click and select the optionformat cell
Now select the option custom
And type dddd in the column
Click okay, and this will get converted to the day
How to get a weekday name in excel from a date: Text Function
The Text Function is one of the most useful functions that can be used in Excel. The Text Function allows you to convert text into a number, currency, date or time. The Text Function also enables you to apply formatting and conditional formatting to the converted text.
The syntax of text function is
Text (Value,Format)
Value represents the cell number which we want to convert into day
Here’s how we do this
1.Name the text in which date is placed and type “dddd” as format in text function like the example given below.
2.This will automatically convert it to the day of that date as shown below
3.Now you know how to convert a date into day using text function
How to get a weekday name in excel from a date: WEEKDAY Function
The WEEKDAY function returns the name of the weekday that contains a given date.For example, to find out what day of the week a given date is on, use the following formula:
WEEKDAY (Value, number)
1.It functions same as the Text function but the change here is that we use number instead of using “dddd”
2.Select the cell you want your output as
3.Type the function.
4.And here the results we get is 1, as you see 1 stands for Sunday ,that means it was Sunday on that date.
Now you know how to obtain weekday name in excel using WEEKDAY function
Did you learn about how to to obtain weekday names from a date in Excel You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides.
You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to compare two excel sheets and highlight differences
- 6. How to add text to beginning or end of all cells in Excel