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)