MONTH Function in Google Sheets

Extract the month from a given date using the MONTH function.

MONTH Function

The MONTH function in Google Sheets extracts the month from a given date.

Syntax

MONTH(date)
  • date: The date from which to extract the month.

Examples

  1. Extract Month from Date

Extract the month from 2024-08-14:

=MONTH("2024-08-14")
  1. Extract Month from Current Date

Extract the month from today’s date:

=MONTH(TODAY())

Notes

  • Returns an integer between 1 and 12.
  • Supports different date formats.
  • DAY: Extracts the day from a date.
  • YEAR: Extracts the year from a date.