MONTH function

Description

This function returns the month portion of date as number in between 1 to 12 for the given date. MONTH function can also extract a month number from a date into a cell.

​

Objective

Returns number of month as a number from 1 to 12..

​

Syntax

=MONTH(date)

​

Arguments

date - Valid date-time format used by Excel.

​