MONTH

Description

The MONTH function finds the month of a given date.

Usage

MONTH(date)
Argument Type Required Description
date date yes The date for which to find the month

Remarks

The result will always be in the range 1 and 12.

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
MULTIPLY (*)