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 (Date)
The date of the year you are trying to find.
datetime (DateTime)
Date with time of the year you are trying to find.
utc (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