## How to use the MONTH function

*Article 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. |

### Articles with the 'MONTH' Function

The following 7 articles have formulas that contain the MONTH function.

Count unique distinct values within same week, month or year

Introduction What are unique distinct values? Unique distinct values are all values but duplicates are merged into one value. Count […]
Question: I have a table with four columns, Date, Name, Level, and outcome. The range is from row 3 to […]

Conditional formatting formula to highlight max value in every month: =B2=MAX(IF(MONTH(A2)=MONTH(Date_rng), Close, "")) Conditional formatting formula to highlight min value […]

Color odd months Conditional formatting formula: =MOD(MONTH($B6),2) Color even months Conditional formatting formula: =NOT(MOD(MONTH($B6),2)) Color odd years Conditional formatting formula: […]

Table of contents Remove duplicates within same month and year in excel Remove duplicates within same year in excel Remove […]

Highlight duplicates on the same date Conditional formatting formula: =SUMPRODUCT(--($C3&"-"&$D3=$C3:$C$3&"-"&$D3:$D$3))>1 Highlight duplicates on same week Conditional formatting formula: =SUMPRODUCT(--($B16&"-"&YEAR($C16)&"-"&$D16=$B16:$B$16&"-"&YEAR($C16:$C$16)&"-"&$D16:$D$16))>1 Highlight […]

The formula in cell C3 calculates the last date for the given month and year in cell B3. =DATE(YEAR(B3), MONTH(B3)+1, […]

### Functions in 'Date and Time'

The MONTH function function is one of many functions in the 'Date and Time' category.

The DATE function returns a number that acts as a date in the Excel environment. The image above shows you […]

The DATEDIF function returns the number of days, months, or years between two dates. The DATEDIF function exists in order to […]

The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. Excel Function Syntax […]

The DAY function extracts the day as a number from an Excel date. Formula in cell C3: =DAY(B3) Excel Function […]

The DATE function calculates the number of days between two dates. Formula in cell D3: =DAYS(B3,C3) Excel Function Syntax DAYS(end_date, […]

The EDATE function returns a date determined by a start date and a number representing how many months. Use EDATE […]

The EOMONTH function returns an Excel date for the last day of a given month using a number and a start […]

Returns an integer representing the hour of an Excel time value. The returning number is ranging from 0 (12:00 A.M.) […]

Returns a whole number representing the minute based on an Excel time value. The returned number is ranging from 0 […]

Extracts the month as a number from an Excel date. Formula in cell C3: =MONTH(B3) Excel Function Syntax MONTH(serial_number) Arguments […]

The NETWORKDAYS function returns the number of working days between two dates, excluding weekends. It also allows you to ignore […]

The NOW function returns the current date and time. Formula in cell B3: =NOW() Excel Function Syntax NOW() Arguments The […]

Returns an integer representing the second based on an Excel time value. The returning number is ranging from 0 to […]

The TIME function returns a decimal value between 0 (zero) representing 12:00:00 AM and 0.99988426 representing 11:59:59 P.M. Formula in cell […]

The TIMEVALUE function returns a decimal number based on a text string. Excel uses decimal numbers between 0 and 0.99988426 […]

The TODAY function returns the Excel date (serial number) of the current date. Warning! This function is volatile meaning it […]

Converts a date to a weekday number from 1 to 7. Formula in cell D3: =WEEKDAY(B3) Excel Function Syntax WEEKDAY(serial_number,[return_type]) […]

The YEAR function converts a date to a number representing the year in the date. The number is between 1900 […]