YEAR

Description

The YEAR function finds the year of a given date.

Usage

YEAR(date)
Argument Type Required Description
date date yes The date for which to find the year

Remarks

The result will be a number representing the four-digit year.

Example

If your fiscal year starts in August, you can calculate the fiscal year from a TRAINING_DATE:

IF(MONTH(TRAINING_DATE) < 8, YEAR(TRAINING_DATE), YEAR(TRAINING_DATE) + 1)
Next item
IF