MONTH

Returns the month of a given date.

Syntax:

MONTH(date)

returns the month of date as a number, where January is 1 and December is 12. date may be text or a date-time serial number.

Example:

MONTH("2021-12-04")

returns 12.

MONTH(A1)

where cell A1 contains the date 1 Nov 2021 as a date-time serial number, returns 11.

Application:

Here's an application of MONTH function:

Scenario: Tracking Monthly Sales Performance

Imagine you're a sales manager, and you have a table with a list of sales transactions, including the date each sale occurred. You want to quickly see which month each sale falls into.

Table:

	Sale ID	Sale Date	Product Sold	Sales Amount	Month
	A	B	C	D	E
1	101	1/15/2024	Laptop	$1,200.00	1
2	102	1/28/2024	Monitor	$300.00	1
3	103	2/5/2024	Keyboard	$75.00	2
4	104	2/19/2024	Mouse	$25.00	2
5	105	3/10/2024	Webcam	$50.00	3
6	106	3/22/2024	Headset	$150.00	3
7	107	4/1/2024	External HDD	$100.00	4

For each row in your table, the MONTH function is applied to the corresponding "Sale Date".

For Sale ID 101, the "Sale Date" is 2024-01-15. When the formula MONTH(B1) is applied, the MONTH function recognizes January as the first month of the year, so the result in the "Month" column is 1.
Similarly, for Sale ID 102, the "Sale Date" is 2024-01-28. The MONTH function again identifies January, so the result is 1.
Moving to Sale ID 103, the "Sale Date" is 2024-02-05. As February is the second month, the MONTH function returns 2.
For Sale ID 104, with the "Sale Date" 2024-02-19, the result is also 2 for February.
When the "Sale Date" is 2024-03-10 for Sale ID 105, the MONTH function correctly extracts March as the third month, resulting in 3.
Similarly, for Sale ID 106 with the "Sale Date" 2024-03-22, the result is 3.
Finally, for Sale ID 107, the "Sale Date" is 2024-04-01. Since April is the fourth month, the MONTH function yields 4.