WEEKDAY Function - Google Sheets
The WEEKDAY function accepts a date and returns the week number of that date. The date must be in avalid format, so you have to use theDATE 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 theDATE functionto combine them.
date- The date for which you want the week number. This is required.
[type]- Optional specification of which numbers scheme to use for the days of the week,
- 1 - Sunday = 1, Monday = 2, etc.
- 2 - Monday = 1, Tuesday = 2, etc.
- 3 - Monday = 0, Tuesday = 1, etc.
DATE- Takes separate year, month, and day values and returns them as a date
DATEVALUE- Returns the serial value of a date
DAY- Returns the value the day from a given date
#NUM- The input is a number but is not a valid date. This could happen if you used the 35th day of November.
#VALUE!- The input is something that doesn't convert to a number such as "The other day" or "Yester-yester-day".
Live examples in Sheets
Go tothis spreadsheetfor the examples of the WEEKDAY function shown above that you can study and use anywhere you would like.