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.)
    • 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.