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

WEEKNUM

Description

Returns an integer from 1 to 53 representing the week number of the specified date.

Syntax

WEEKNUM(
serial_date
, [
return_type
])
  • serial_date
    : The serial number representing the date.
  • return_type
    : The code specifying the week numbering system to use and the first day of the week. In week numbering system 1, the week of January 1st is Week 1; in week numbering system 2, the week containing the first Thursday of the year is Week 1.
    return_type
    Description
    1
    Numbering system 1 and the week runs from Sunday to Saturday.
    2
    Numbering system 1 and the week runs from Monday to Sunday.
    11
    Numbering system 1 and the week runs from Monday to Sunday.
    12
    Numbering system 1 and the week runs from Tuesday to Monday.
    13
    Numbering system 1 and the week runs from Wednesday to Tuesday.
    14
    Numbering system 1 and the week runs from Thursday to Wednesday.
    15
    Numbering system 1 and the week runs from Friday to Thursday.
    16
    Numbering system 1 and the week runs from Saturday to Friday.
    17
    Numbering system 1 and the week runs from Sunday to Monday.
    21
    Numbering system 2 and the week runs from Monday to Sunday.

Example

Formula
Result
=WEEKNUM("10/4/2016 5:37 PM")
41
=WEEKNUM("10/4/2016",21)
40

This content is not part of the Workday Administrator Guide.