You can use the WEEKDAY function in Google Sheets to get the day of the week number. It’s precisely there in the Google Sheets to return the number from 1 to 7 to show the date’s day.
Get Day of Week with WEEKDAY
- First, enter the WEEKDAY function in a cell.
- And in the first argument (date), refer to the cell where you have the date, or you directly insert the date within the cell.
- Now, in the second argument (type), enter 2. This argument tells the function to consider Monday as the first day of the week.
- In the end, close the function and hit enter to get the result in the cell.
As you can see in the above example, 1 in the result as the date “02-Jan-2023” has Monday as a day, and Monday is the first day in the week (per our formula).
=WEEKDAY(A1,2)And if you change the (type) argument to 1, which means the starting of the week is from Sunday, it returns 2 in the result, which makes Monday the second day of the week.
=WEEKDAY(A1,1)But if you use 3 in the (type) argument, it will consider Monday as the first day of the week and gives it 0 as the start number of the week. That means the range of the week will be 0-6.
In this function, type argument is optional, and if you skip specifying it, the function will consider 1 as a default value and use Sunday as the first day of the week.
=WEEKDAY(A1)Get the Day Name Instead of the Number
You can use the below steps for this:
- Enter (=) in a cell.
- Type “TEXT” to enter the text function.
- Refer to cell A1, where you have the date.
- Specify the format in which you want to get the name “ddd” (short name) or “dddd” (for the long name).
- Insert the closing parentheses and hit enter to get the result.
When you hit enter, it returns the day’s name in the result.
=TEXT(A1,"DDDD")Other than that, you can also use:
=CHOOSE(WEEKDAY(A1),"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday")=CHOOSE(WEEKDAY(A1),"Mon","Tue","Wed","Thu","Fri","Sat","Sun")=TEXT(A1,"DDD")
All the above formulas work in the same way and give you the day’s name from the date you specify in the formula.