Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
WEEKDAY

WEEKDAY

Description

Returns an integer representing the day of the week.

Syntax

WEEKDAY(
date
, [
return_type
])
  • date
    : The serial date to get the day value from.
  • return_type
    : The code specifying the integer to assign to each day of the week. The default
    return_type
     is 1. (1 = Sunday, 2 = Monday, and so on.)
    Return_type
    Description
    1
    1 = Sunday, 2 = Monday, and so on.
    2
    1 = Monday, 2 = Tuesday, and so on.
    3
    0 = Monday, 1 = Tuesday, and so on.
    11
    1 = Monday, 2 = Tuesday, and so on.
    12
    1 = Tuesday, 2 = Wednesday, and so on.
    13
    1 = Wednesday, 2 = Thursday, and so on.
    14
    1 = Thursday, 2 = Friday, and so on.
    15
    1 = Friday, 2 = Saturday, and so on.
    16
    1 = Saturday, 2 = Sunday, and so on.
    17
    1 = Sunday, 2 = Monday, and so on.

Example

Formula
Result
=WEEKDAY("12/31/2016 5:37 PM",1)
7
=WEEKDAY("12/31/2016",3)
5

Notes

  • To format the result as a weekday name instead of a number, select
    Format
    Number
    Custom
     and enter the formatting string
    ddd
     .

This content is not part of the Workday Administrator Guide.