WEEKDAY
Pull the day-of-week pattern out of dates.
Why planners need it
Volume lives on day-of-week. WEEKDAY lets you average Mondays, flag weekends, or build a 7-day profile from a date column.
Syntax
=WEEKDAY(date, [return_type])
Worked example
Tag each date, then average like days:
=WEEKDAY(date, 2) → Monday = 1 … Sunday = 7 (type 2 is the planner-friendly one).
Average all Mondays: =AVERAGEIFS(Vol, Dow, 1).
Watch out: The default return_type makes Sunday = 1, which trips people up — use type 2 for Monday = 1.