Syntax

WEEKDAY(when)

Description

WEEKDAY() interprets when (a Text value) as a Date value and returns the day of the week it represents.

Return Value

A Number value: the day of the week as a number (1 to 7; 1 is Sunday) if found in when or 0 if not.

Did this answer your question?