Year

Description of formula:
Extracts the year from a date passed in as parameter. The returned year is a number in the range 1-9999.
Syntax:
YEAR(date|datetime|utc)
Parameters:
date (type:Date)
The date of the year you are trying to find.
datetime (type:DateTime)
Date with time of the year you are trying to find.
utc (type:UTC)
The date with time in a UTC format of the year you are trying to find.
Returned type:
Number
examples:
=year(datetime(2016,1,1,1,1)) - returns 2016
=year(A1) - returns year of a date from cell A1
=year(date(2012,3,4))
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk