Excel MONTH Formula
In this tutorial, you will learn in detail about excel MONTH function. Excel MONTH formula is useful to take the month number from a date data.
Why do We Need to Learn Excel MONTH Formula?
In the processing process on a spreadsheet, often we find the need to extract the middle number from a date data to help the analysis process that we do. This is sometimes needed because we want to see the comparison of indicators per that period or we just need to recap monthly data in our spreadsheet for a specific purpose.
As a case example for the need in our work, imagine we want to recap all the data related to the sales of a company product monthly. In the processing that we do for the need, maybe the data that we have in the spreadsheet currently is the daily sales numbers of the product with the date for each of the entries. If we want to get that period number that we need so that we can do the monthly recap faster using formulas or other spreadsheet functions, then we need to extract the numbers from the dates column of the daily sales entries. If the data amount is much, then, of course, it will take a lot of time and be troublesome if we do it manually.
To help in getting the number a lot faster for each of the dates data on the spreadsheet, then we can use excel MONTH formula. Excel MONTH function will help you to extract that period number from a date. This is very useful to be understood if we often deal with dates or periodically based data groupings in the spreadsheet.
What is the Excel MONTH Function?
Excel MONTH function is a function with the usage objective to get a month number from a date data. Excel MONTH formula is often used if you need to do recap based on that period in the spreadsheet.
Generally, the input of this function can be explained briefly as follows:
=MONTH(serial_number)
Note:
serial_number = the date that you want to process
How to Use Excel MONTH Formula?
The following will explain the writing steps for the excel MONTH formula. The excel MONTH function only needs one input which is the date that you want to process to get the number that you want.
Using Excel MONTH Function

Type equal sign ( = ) in the cell where you want to put the result in

Type MONTH (can be with large and small letters) and open bracket sign after =

Type date or cell coordinate where the date which you want to process is, after open bracket sign

Type close bracket sign
 Press Enter

The process is done!
Exercise
After you have understood how to use excel MONTH function, now is the time you deepen your understanding by doing the exercise below!
Download the exercise file and answer all the questions! Download the answer key file if you have done the exercise and want to check your answers or when you are confused about how to complete the exercise!
Link for the exercise file:
Download here
Questions
Answer each of these questions on the appropriate graycolored cells! What is the content of the first column cells which are still blank for each of the products?
 What is the content of the second column cells which are still blank for each of the products?
 How many is the monthly sales amount of the company? Use the SUMIF formula to help you in answering this question by also utilizing your answer on the previous question!
Link for the answer key file:
Download here
Additional Note
If you want to extract the day or year number of date, then you can do it by using the DAY (for the day) and YEAR (for the year) formulas in the spreadsheet.