WEEKDAY Function – Google Sheets
The WEEKDAY function returns a number representing the day of the week for a specific date. By default, it counts Sunday as <code>1</code> and Saturday as <code>7</code>, but you can change this using the optional <code>type</code> argument. The date must be in a valid format, so you have to use the DATE function, wrap it … Read more