Weekday name from date in google sheets

In this article, we will learn how to get the weekday name from date in google sheets.

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:

Weekday name from date in google sheets example


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.

Weekday name from date in google sheets example


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

30+ smart tools to supercharge your sheets