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

DATE

Description

Returns the date based on the specified year, month, and day.

Syntax

DATE(
year
,
month
,
day
)
  • year
    : The integer representing the year.
  • month
    : The integer representing the month.
  • day
    : The integer representing the day.

Example

Formula
Result
=DATE(2016,7,15)
"7/15/2016"

Notes

  • If the result is a numeric value instead of a date, check the formatting for the cell to make sure it's set to
    Date
     .

Related Functions

DATESBETWEEN

This content is not part of the Workday Administrator Guide.