Bishawajit Chakraborty
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 Excel formula.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
4 Ways to Count Months from Date to Today by Using Excel Formula
This article will demonstrate how to count months from date to today in Excel by using the MONTH function, applying the DATEDIF function, inserting the YEARFRAC function, and nesting the YEAR and MONTH functions. Let’s suppose we have a sample dataset.
Method 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 the E5 cell.
- Then, write down the following formula.
=MONTH(D5)-MONTH(C5)- After that, press Enter.
- So, 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 the E5 cell to the E13 cell.
- Finally, you will get the number of months for all the people in the data set.
Read More: Calculate Years and Months between Two Dates in Excel (6 Approaches)
Method 2: Applying Excel Formula with DATEDIF Function to Count Number of Months from Date to Today
The use of the DATEDIF function is also a way to count months between Excel dates. It is specially intended to determine the time difference in different units, including days, months, and years.
Steps:
- Firstly, select the E5 cell.
- Then, 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 the E5 cell to the E13 cell.
- Lastly, 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 Number of Months Between Two Dates in Excel
Similar Readings
- How to Add Months to a Date in Excel (2 Ways)
- Minus Number of Days or a Date from Today in Excel
- How to Add Years to a Date in Excel (3 Easy Ways)
Method 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:
- Firstly, select the E5 cell.
- 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 the E5 cell to the E13 cell.
- 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 Subtract Dates in Excel to Get Years (7 Simple Methods)
Method 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:
- Firstly, select the E5 cell.
- Then, write down the following formula.
=(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 the E5 cell to the E13 cell.
- 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 Between Two Dates in Excel (2 Methods)
Conclusion
In this article, we’ve covered 4 Ways to Count Months from Date to Today by Using 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, ExcelDemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.
