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

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

    Excel MONTH Formula - Screenshot of Step 1

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

    Excel MONTH Formula - Screenshot of Step 2

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

    Excel MONTH Formula - Screenshot of Step 3

  4. Type close bracket sign

    Excel MONTH Formula - Screenshot of Step 4

  5. Press Enter
  6. The process is done!

    Excel MONTH Formula - Screenshot of Step 6



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 gray-colored cells!
  1. What is the content of the first column cells which are still blank for each of the products?
  2. What is the content of the second column cells which are still blank for each of the products?
  3. 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.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on




Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert