In this article, we will learn how to get the weekday name from date in google sheets.
In above screenshot, if cell A1 has a date 24-April-2022 then in cell A2, you need to show Sunday as the weekday name.
Here is how to get a weekday name:
1. Open google sheets on your computer or mobile
2. Write the date in date format in cell A1
3. In B1 write =WEEKDAY(A1) to output the day of the week
4. Use the IFS formula to output the day name based on a day in B1
5. =IFS(B1=1, “Sunday”, B1=2, “Monday”,….)
The IFS formula to output each weekday name from date in google sheets is:
=IFS(B1=1, "Sunday", B1=2, "Monday", B1=3, "Tuesday", B1=4, "Wednesday", B1=5, "Thursday", B1=6, "Friday", B1=7, "Saturday")
Here is an animation showing this in action:
Explanation of the formula
WEEKDAY() formula outputs the current weekday number from 1 to 7.
If no second parameter is passed, then WEEKDAY(A1) will assume Sunday is the start of the week and assign 1 to it. Hence Monday will be 2, Tuesday 3 and so on.
First, you need to get the weekday number using the weekday() formula. Then use an IFS statement to iterate through the number to assign it to a weekday name.
Example – Weekday name from date in google sheets
Below we have a list of dates in column A. Column B has the weekday() formula to tell you which weekday number it is. Finally, in column C, you have the IFS formula to output the weekday name.
Wrapping up
In this tutorial, we learned about how to get weekday name from date in google sheets. Now go ahead and use this in your worksheet. Let me know in the comments if you have any issues.
Appendix
[1] WEEKDAY formula in google sheets – Link
Further Reading
New to google sheets ? Start here
More related to Formulas:
Learn more about Google sheets Formulas.
Logical functions in google sheets
Error handling in google sheets
