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.
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:
- In the cell to calculate enter the formula: = MONTH (F7).
- Press Enter -> return month value is:
- Similarly copying the formula for the remaining values results:
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
Maybe you are interested
YouTuber spent 14 months building a gaming laptop from desktop parts: The final result is amazing!
Solar electric vehicles that can run for 7 months without charging are being put into mass production
CrowdStrike also crippled global Debian and Rocky Linux systems many months ago, but no one noticed!
How to adjust time on Windows 10, change day and month time when error occurs
Why do people only stay in submarines for a maximum of 90 days, but can stay in space for 6 months or more?
What is Pride Month? Why does Pride Month start in June?