Google Sheets Day of Week is easy to find with
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.
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.
1, days are counted from Sunday and the value of Sunday is 1, therefore the value of Saturday is 7.
2, days are counted from Monday and the value of Monday is 1, therefore the value of Sunday is 7.
3, days are counted from Monday and the value of Monday is 0, therefore the value of Sunday is 6.
- 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
TO_DATE, or a date serial number of the type returned by the
Nfunction. 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.
WEEKDAYdoes 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.
WEEKDAYreturns 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
TEXTfunction 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.