MONTH

Definition of MONTH

Returns the month of the year a specific date falls in, in numeric format.

Sample Usage

MONTH(DATE(1969, 7, 20))

MONTH(A2)

MONTH(40909)

MONTH("7/20/1969")

Syntax

MONTH(date)

• date - The date from which to extract the month. Must be a reference to a cell containing a date, a function returning a date type, or a number.

Notes

• Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as DATE, DATEVALUE or TO_DATE, or a date serial number of the type returned by the N function.
• MONTH does not autoconvert number formats. Therefore, MONTH(10/10/2000) is interpreted as MONTH(0.005), the quotient of 10 divided by 10 divided by 2000.
• MONTH returns the intuitive understanding of the month of the year, and is useful primarily in other calculations rather than to extract the month from a known date, as that value is easily known from a plain reading of the entire date.

See Also

YEAR: Returns the year specified by a given date.

WEEKDAY: Returns a number representing the day of the week of the date provided.

TO_DATE: Converts a provided number to a date.

N: Returns the argument provided as a number.

DAY: Returns the day of the month that a specific date falls on, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a provided year, month, and day into a date.

In order to use the MONTH formula, start with your edited Excellentable

Then type in the MONTH Formula in the area you would like to display the outcome:

By adding the values you would like to calculate, Excellentable generates the outcome:

	A	B	C
1	State	Population	Total area in mi2	Land area in mi2	Water area in mi2
2	Alabama	4833722	52,420 (135,767)
3	Alaska	735132	665,384 (1,723,337)
4	Arizona	6626624	113,990 (295,233)
5	Arkansas	2959373	53,179 (137,733)
6	California	38332521	163,695 (423,968)
7	Colorado	5268367	104,094 (269,602)
8	Connecticut	3596080	5,543 (14,356)
9	Delaware	925749	2,489 (6,446)
10	Florida	19552860	65,758 (170,312)
11	Georgia	9992167	59,425 (153,910)
12	Hawaii	1404054	10,932 (28,314)
13	Idaho	1612136	83,569 (216,443)
14

	D	E	F
1

Date

MONTH