How to Count Months from Date to Today by Using Excel Formula

Get FREE Advanced Excel Exercises with Solutions!

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.

Count Months from Date to Today by Using Excel Formula


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.

Using Formula with MONTH Function to Count the Number of Months from Date to Today in Excel

  • 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.

Applying Excel Formula with DATEDIF Function to Count Number of Months from Date to Today

  • 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.

Inserting Excel Formula with YEARFRAC Function to Count Months from Date to Today

  • 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.

Nesting YEAR and MONTH Functions to Count Months from Date to Today by Excel Formula

  • 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


<< Go Back to Days Between Dates | Calculate Dates | Date-Time in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Bishawajit Chakraborty
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo