The YEAR
function returns the year
when given a date value.
- The syntax
for the function is YEAR (date)
. The "date"
must be a date value or a recognizable
date format in Excel.
Excel recognizes
other date formats and automatically
converts them into date values then
the year is extracted from
the date value and a number is given
between 1900 and 9999.
For example: YEAR
(14-May-2003) = 2003 and YEAR (12/31/2003)
= 2003.
In addition the
YEAR function can extract the year
directly from the date value YEAR(39099)
=2007
|
