MONTH function - The function converts a serial number into a month in Excel

The following article details how to use the MONTH function, the function converts a serial number into a month in Excel.

Description: The function separates month values in a specific date time. The return month value is an integer between 1 and 12.

Syntax : MONTH (serial_number) .

Inside:

serial_number is the date and month we want to separate the month.

For example:

Separate month values from the following dates:

MONTH function - The function converts a serial number into a month in Excel Picture 1

In the cell to calculate enter the formula: MONTH (C7) .

MONTH function - The function converts a serial number into a month in Excel Picture 2

Press Enter -> separated month results:

MONTH function - The function converts a serial number into a month in Excel Picture 3

Copying the formula to the remaining cells results:

MONTH function - The function converts a serial number into a month in Excel Picture 4

If the date entered is wrong, the month exceeds December -> the function returns the #VALUE error value.

MONTH function - The function converts a serial number into a month in Excel Picture 5

Above is the usage and some notes when using the MONTH () function .

Good luck!

Lesley Montoya

Update 19 May 2020

You should read it

NOW function - The function returns the current date and time in Excel
now function: the function returns the current date and time. the now function is useful when you want to display the current date and time. the now function does not update continuously, it only updates when you have editing operations on the data area containing it.
Instructions on how to enter chemical formulas in Excel
the following article details how to enter chemical formulas in excel.
How to reduce the size and size of Word document files containing images
the following article details how to reduce the size of word documents 2016, 2010, 2007 containing images without using additional software.
How to insert images into Excel spreadsheets
the following article details how to insert images into excel spreadsheets. for example, want to insert an image as a symbol for the subject.
How to insert, add Up and Down buttons in Excel
to facilitate the work of data entry you can insert up and down buttons. the following article details how to insert up and down buttons in excel.
Instructions to recover data with Wise Data Recovery
if you accidentally delete or format the data wrongly, don't worry too much, try the wise data recovery data recovery program as instructed below with a very high ability to rescue data.