Date

Description of formula:
DATE function returns the ordinal number representing a specific date
Syntax:
DATE(year, month, day)
or
DATE(datetime)
or
DATE(UTC)
Parameters:
year(type:number)
The value of the year may contain from one to four digits. 
month(type:number)
Number ranging from 1 to 12, which is the month of the year (January to December).
day(type:number))
Number ranging from 1 to 31, which means the day of the month.
datetime(type: datetime)
Datetime, you want to convert to date
UTC(type:UTC)
Datetime UTC, you want to convert to date
Returned type:
Date
examples:
=date(2016,1,1)
=date(section1.A1, section1.A2, section1.A3)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk