WEEKDAY function

Prev Next

Description

Returns the day of the week of the given Date.

Syntax

WEEKDAY(Date)

Arguments

Argument

Type

Dimensions

Description

Date

(required)

Date

Any Dimensions

Date to get the weekday from.

Returns

Type

Dimensions

Integer

Dimensions of argument Date

Examples

Formula

Result

Description

WEEKDAY(DATE(2020, 12, 02))

3

The date December 2nd 2020 is a Wednesday, the result is 3.

WEEKDAY(DATE(2020, 12, 06))

0

The date December 6th 2020 is a Sunday, the result is 0.

See also

Excel: WEEKDAY

Related articles: DAY

More of a hands-on learner?

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace.  It includes examples of every formula and modifier in Pigment!