MONTH
The MONTH function extracts the month value from a date. The input date should be in MM/DD/YYYY format. References are also accepted as arguments. This function is commonly used to analyze and group data by month.
Syntax
MONTH(date)Arguments
date: The input date.
Return value
Returns the month value from the specified date.
Example
MONTH("3/21/2023")Returns 3.
Excel equivalent
Last updated
Was this helpful?