DATE function

  • 21 December 2021
  • 0 replies
  • 205 views

Userlevel 3
Badge

 

Description

Creates a date with the given year, month and day.

 

Syntax

DATE(year, month, day)
  • year should be between 1 and 9999

  • month should be between 1 and 12

  • day should be between 1 and 31

 

Return type

Date

 

Examples

Case

Results

Return Type

DATE(2020, 12, 02)

"12/02/2020"

Date

 


Excel equivalent: DATE(year, month, day)


0 replies

Be the first to reply!

Reply