How to extract month from a date in Excel | How To Use Month Function In Excel | #Month

MONTH ()

The Excel MONTH function extracts the month from a given date as
number between 1 to 12. You can use the MONTH function to extract a month
number from a date into a cell, or to feed a month number into another
function like the DATE function.

Purpose
Get month as a number (1-12) from a date
Return value
A number between 1 and 12.
Syntax
=MONTH (serial_number)
Arguments
serial_number - A valid Excel date.

The MONTH function extracts the month from a given date as a number between 1 to 12. For example, given the date "June 12, 2021", the MONTH function will return 6 for June. MONTH takes just one argument, serial_number, which must be a valid Excel date.

Dates can be supplied to the MONTH function as text (e.g. "13-Aug-2021") or as native Excel dates, which are large serial numbers. To create a date value from scratch with separate year, month, and day inputs, use the DATE function.

The MONTH function will "reset" every 12 months (like a calendar). To work with month durations larger than 12, use a formula to calculate months between dates.

The MONTH function returns a number.

You can follow us on the below social media handles:-