Returns the month of the year for a given date (1-12).

MONTH(Date)

Date: the date for which the month value is to be determined.

MONTH(CALCDATE) will return the month of the calculation date