next up previous contents index
Next: YEARFRAC Up: A. Function Reference Previous: XVALUE   Contents   Index


YEAR

Syntax: YEAR(DT)

DT = a date/time value

YEAR returns the years component of the date/time value DT, where 1900 = 0.

Examples:

YEAR(24203) = 66, where 24203 represents April 6, 1966

YEAR(TODAY()) = 90, where TODAY() = December 25, 1990

YEAR(366) = 0, where 366 represents December 31, 1900

Excel function: YEAR


next up previous contents index
Next: YEARFRAC Up: A. Function Reference Previous: XVALUE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003