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.
MM/DD/YYYY
MONTH(date)
date: The input date.
date
Returns the month value from the specified date.
MONTH("3/21/2023")
Returns 3.
3
MONTH
Last updated 1 month ago
Was this helpful?
