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)
Parameters:
date (Date)
-
Returned type:
Number
examples:
=year(date(2016,1,1,1,1)) - returns 2016
=year(A1) - returns year of a date from cell A1
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk