Buzz
Mastering the MONTH Function in Excel - Illustrated Examples
Syntax: MONTH( Serial_number)
Where: Serial_number is a required value. It represents the date value of the month you want to find.
Purpose: Extracting the month value from a specific date. The month is returned as an integer, ranging from 1 to 12.
Illustration: - Example 1: =MONTH(DATE(6/6/2014))=6. - Example 2: Assume we have the spreadsheet as shown below and we want to fetch the Month value from the Date column.
Steps to follow: + In cell D6, input as follows: =MONTH(C6) and press Enter. The result of cell D6=6.
+ Click and drag the result for the remaining cells.
Tip: During the process of entering date format data into the spreadsheet, if errors occur, not in the desired format, you can refer to How to Handle Date Errors in Excel for solutions.
In our recent guide, we walked you through utilizing the MONTH function in Excel, enabling you to effortlessly extract month values within your spreadsheet. Additionally, consider exploring the DAY function in Excel for extracting day values.
If you find counting days and months challenging in Excel, employ the DATEIF function - an effective tool for counting days, months, and years in Excel.
