Skip to content

WEEKDAY

Date & Time

WEEKDAY helps you perform date and time helpers for scheduling, intervals, and calendar-aware calculations.

Overview

Start with "=" then enter WEEKDAY(date, [type]). Keep argument order as shown and use cell ranges where appropriate.

Parser pathComplete docs

Syntax & Arity

=WEEKDAY(date, [type])

1 to 2 arguments

Arguments

ArgumentRequiredTypeDescription
dateRequiredSingleDate input value.
typeOptionalSingleOptional argument for advanced control.

Example Inputs & Outputs

Formula

=WEEKDAY(<date>, <type>)

Example Output

Date or time value

Replace placeholders with your worksheet values or ranges to compute a result.

Related Functions