Author: Oscar Cronquist Article last updated on April 19, 2018

Extracts the month as a number from an Excel date.

Formula in cell C3:

=MONTH(B3)

Excel Function Syntax

MONTH(serial_number)

Arguments

serial_number Required. The date value you want to extract the month from.