Syntax

YEAR(when)

Description

YEAR() interprets when (a Text value) as a Date value and returns the year it specifies.

Return Value

A Number value: the year if found in when, or 0 if not found.

Did this answer your question?