Syntax
MONTH(Date)
Date (required) – This is the date value that you want to return the month from.
Example
In this example we use the function on several dates in different formats. Notice the text values we try result in a #VALUE! error while numerical values outside of the range 1 to 2,958,465 result in a #NUM! error.
