Site icon Sheet Natives

Google Sheets Day of Week

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.

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¬†‚Äst[¬†OPTIONAL ‚Äst1¬†by default¬†]¬†‚Äď A number indicating which numbering system to use to represent weekdays. By default counts starting with Sunday = 1.


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.



Exit mobile version