WEEKDAY function

  • 21 December 2021
  • 0 replies
  • 283 views

Userlevel 5
Badge +3

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!

 

 


This topic has been closed for comments