YEAR practice

YEAR returns the year of a date as a number. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.

Syntax

YEAR(date)

Hires per year is COUNTIF on a helper column of YEAR values, or SUMPRODUCT over YEAR(range).

Often used together with: MONTH

The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.