MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel
The following article introduces you to the MONTH function - one of the functions in the date and time group is very popular in Excel.
MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 1
Description: The function returns the month of a day expressed as serial number in Excel. Months are represented by integers with values between 1 and 12 months.
Syntax: MONTH (serial_number)
Where serial_number is the date denoted by the serial number you want to calculate the month value.
Attention:
- Excel stores the date as a serial number to facilitate the calculation process.
- The return value of the function YEAR, MONTH, DAY is a Gregorian value regardless of the display format provided.
For example:
Calculate monthly values in days with different formats:
MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 2
- In the cell to calculate enter the formula: = MONTH (F7).
MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 3
- Press Enter -> return month value is:
MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 4
- Similarly copying the formula for the remaining values results:
MONTH function - The function returns the monthly value of a day expressed as a serial number in Excel Picture 5
Above are instructions and some specific examples when working with the MONTH function in Excel.
Good luck!
You should read it
- MONTH function - The function converts a serial number into a month in Excel
- TIMEVALUE function - The function returns the decimal number of time expressed as a text string in Excel
- MINUTE function - The function converts a serial number into a minute in Excel
- EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel
- HOUR function - The function converts a serial number into an hour in Excel
- MONTH function in SQL Server
- DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Excel
- DAY function in SQL Server
- COUPNUM function - The function returns the number of interest payments on a security in Excel
- The DAY function - The function returns the day of the day, month and year in Excel
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- PERMUT function - The function returns the number of permutations of a given number of objects in Excel
May be interested
NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel
How to insert pictures into Word, Excel and align images
How to insert symbols, special characters in Word
How to set the default font in Word, Excel 2016
How to create a chart in Word 2016
Shortcuts in Powerpoint need to know