dayofweek

The WEEKDAY function accepts a date and returns the number for the day of the week. 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 … Read more