Google Sheets Day of Week

by
weekday

Google Sheets Day of Week is easy to find with WEEKDAY function.

The WEEKDAY function accepts a date and returns the day number of that date. The date must be in a valid format, so you have to use the DATE function, wrap it in quotes, or use a cell reference to a cell containing a date.

If your days, months, and years are in different cells, use the DATE function to combine them.

weekday

Monday or Sunday First?

There are at least six different week numbering systems currently in use around the world.

The most common is the International Standard ISO 8601, where Monday is the first day of the week followed by Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday as the seventh and final day. Using ISO 8601 can help diminish uncertainty and confusion when communicating internationally.

Not ISO 8601 in US & Canada

However, not every country follows this standard. Several countries, including the United States, Canada, Australia, and New Zealand, set Sunday at the start of the week on their calendars.

Week Types in Google Sheets

type – [ OPTIONAL – 1 by default ] – A number indicating which numbering system to use to represent weekdays. By default counts starting with Sunday = 1.

  • If type is 1, days are counted from Sunday and the value of Sunday is 1, therefore the value of Saturday is 7.
  • If type is 2, days are counted from Monday and the value of Monday is 1, therefore the value of Sunday is 7.
  • If type is 3, days are counted from Monday and the value of Monday is 0, therefore the value of Sunday is 6.

Notes

  • Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as DATE, DATEVALUE or TO_DATE, or a date serial number of the type returned by the N function. Google Sheets represents dates internally as numbers for ease of use in calculation, and while this conversion is done automatically when a date in the form of a string is input into a cell, this function does not perform this conversion.
  • WEEKDAY does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, WEEKDAY(10/10/2000) is interpreted as WEEKDAY(0.0005), the quotient of 10 divided by 10 divided by 2000.
  • WEEKDAY returns the day of the week in numeric form, not as a letter (e.g. ‘M’ or ‘F’) an abbreviation (e.g. ‘Tue’ or ‘Thu’) nor as a full day name (e.g. ‘Wednesday’). To get the name of the weekday, use the TEXT function or change the number formatting on the cell.

Find your answer for How to find Google Sheets Day of Week?

Let us know, if this helped you or if you have any questions left. I will do my best to answer your questions.

Cheers

via GIPHY