ProductSolutionsTemplatesResources

WEEKDAY

Returns a number representing the day of the week of the date provided. Learn more

Video field
Date

The WEEKDAY function is a date and time function used in Google Sheets to determine the day of the week for a given date.

The function takes one mandatory argument, which is the date that you want to find the day of the week for, and one optional argument that specifies the type of return value.

The type argument is an integer between 1 and 3 that determines how the function will return the day of the week.

If type is 1 or omitted, the function will return a number between 0 (representing Sunday) and 6 (representing Saturday).

If type is 2, the function will return a number between 1 (representing Monday) and 7 (representing Sunday).

If type is 3, the function will return a text string that represents the day of the week (e.g., "Sunday", "Monday", etc.).

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!