How To Convert Date To Day Of Week in Google Sheets

Last Updated on February 4, 2023 by Jake Sheridan

In this tutorial, you will learn how to convert dates to a day of the week in Google Sheets.

How To Convert Date To Day Of Week in Google Sheets

Do you have a spreadsheet with dates in it, but you need to know the day of the week associated with each of them?

You can use the WEEKDAY function in Google Sheets to easily convert a date to a number that represents a particular day of the week.

If you want to display the actual day of the week, such as “Sunday” or “Mon”, we suggest using the TEXT function instead. Unlike the WEEKDAY function, the TEXT function returns a string that corresponds to the day of the week. This can be helpful if you need to quickly seewhat day of the week it was.

In this guide, we will show you how to use these functions to convert a date to the day of the week in Google Sheets

How To Find the Day of the Week of a Given Date in Google Sheets

Here’s how to find the day of the week of a given date in Google Sheets.

Step 1

We can use the WEEKDAY function to convert dates to a number that represent the day of the week.

By default, the number ‘1’ represents Sunday, the number ‘2’ represents Monday, and so on.

Do note that this function does not convert text values to dates on its own. The user will have to ensure that the value being passed as an argument is already represented as a date in Google Sheets.

Step 2

The WEEKDAY function also includes an optional second argument ‘type’ that allows users to set what day is considered the start of the week.

If the user sets the type to 1, weekdays are counted from Sunday and the value of Sunday is 1.

If the type is set to 2, days are counted from Monday and the value of Monday is 1.

If the user sets the type to 3, days are counted from Monday starting with a value of 0.

Step 3

If you would prefer to return the actual day of the week, you can use the TEXT function. The TEXT function accepts a valid date and a provided date format you want to output the date as.

If we use the format “ddd”, Google Sheets wil return the day of the week as a shortened 3-letter abbreviation.

Step 4

We can use the format “dddd” to return the full day of the week instead.

Summary

This guide should be everything you need to convert a date to a day of the week in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.