The MONTH function returns the month for a given date/time value or date string.
MONTH(date)
date: A date/time value or date string.
Example
=MONTH(“April 6, 1988 11:59:22pm”) returns 4.
