Counting the number of months in Excel is a significant task in our day-to-day activities. It’s necessary to count the months when keeping track of various projects, tasks, and other things. We must tally the months from the commencement date to the current date in order to keep track. In this article, we will discuss how to count the number of months from date to today by using the Excel formula.
This article will demonstrate how to count months from date to today in Excel by using different functions like MONTH, DATEDIF, YEARFRAC, and YEAR. Let’s suppose we have a sample dataset.
1. Using Formula with MONTH Function to Count the Number of Months from Date to Today in Excel
In this section, we will demonstrate how to use the MONTH function to count the number of months from date to today.
Steps:
- Firstly, select cell E5.
- Then, write down the following formula.
=MONTH(D5)-MONTH(C5)
- After that, press Enter.
- You will see the number of months between the first person’s joining date and today’s date.
- Then, use the Fill Handle tool and drag it down from cell E5 to E13.
- Finally, you will get the number of months for all the people in the data set.
Read More:Â How to Calculate Number of Months Between Two Dates in Excel
2. Applying Excel Formula with DATEDIF Function to Count the Number of Months from Date to Today
The use of the DATEDIF function is also a way to count months in Excel between dates in Excel. It is specially intended to determine the time difference in different units, including days, months, and years.
Steps:
- Select cell E5 and write down the following formula.
- So, the formula for our data set is given below where D5 is the date of the current day and C5 is the date of joining date. Also, M refers to months (full months).
=DATEDIF(C5,D5,"M")
- After that, press Enter.
- Then, you will see the number of months between the first person’s joining date and today’s date.
- Besides, use the Fill Handle tool and drag it down from cell E5 to E13.
- Lastly, the given image shows the number of months between the joining date and today’s date in the data set.
Read More:Â Excel Formula to Calculate Number of Days Between Today and Another Date
3. Inserting Excel Formula with YEARFRAC Function to Count Months from Date to Today
Here, we will demonstrate how to apply the YEAERFRAC function to count the number of months from date to today in Excel.
Steps:
- Select cell E5.
- Then, write down the following formula.
=INT(YEARFRAC(C5,D5)*12)
- In this formula, the YEARFRAC function shows the number of years, so we multiply the number of years by 12 to count the number of months.
- Then, we will apply the INT function to convert the months into an integer value.
- After that, press Enter.
- Then, you will see the number of months between the first person’s joining date and today’s date.
- Besides, use the Fill Handle tool and drag it down from cell E5 to E13.
- Therefore, the given image shows the number of months between the joining date and today’s date in the data set.
Read More:Â How to Calculate Years from Today in Excel
4. Nesting YEAR and MONTH Functions to Count Months from Date to Today by Excel Formula
In this last section, we will apply the combined formula of the YEAR and MONTH functions to count the number of months from date to today.
Steps:
- Write down the following formula on cell E5.
=(YEAR(D5)-YEAR(C5))*12+ MONTH(D5)-MONTH(C5)
- After that, press Enter.
- Then, you will see the number of months between the first person’s joining date and today’s date.
- Besides, use the Fill Handle tool and drag it down from cell E5 to E13.
- Therefore, the given image shows the number of months between the joining date and today’s date in the data set.
Read More:Â Calculate Years and Months Between Two Dates in Excel
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
Conclusion
In this article, we’ve covered 4 ways to count months from date to today by using the Excel formula. We sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.
Related Articles
- Excel Calculates Difference Between Two Dates in Days
- Excel Formula to Count Days from Date
- How to Calculate Expiration Date with Excel Formula
- How to Find Number of Weeks Between Two Dates in Excel
- How to Calculate Years Between Two Dates in Excel
- Calculate Number of Days between Two Dates with VBA in Excel
<< Go Back to Days Between Dates | Calculate Dates | Date-Time in Excel | Learn Excel