Multiple choice technology web technology

Converts a serial number to a year

  1. YEAR

  2. YEARS

  3. YEARFRAC

  4. YEARSFRAC
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The YEAR function extracts the year component (as a 4-digit number) from a date serial number. This is straightforward and commonly used in date analysis. YEARS and YEARSFRAC are not standard Excel functions (YEARFRAC exists but serves a different purpose).

Keep practicing — related questions