Year for Date Number [YearFor#]

Return to Complete List of Functions

The Year for Date Number function determines the four-digit year for a date specified as a date number. Parameters ------------------ Date Number     The number of days between a given date and December 30, 1899.                           This value is typically generated based on the Date As Number function. Function Value ------------------------ This function extracts the year from the date specified as a date number and returns it as a four digit number.