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

Count Months from Date to Today by Using Excel Formula


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.

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

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

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


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.

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

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


Related Articles

Bishawajit Chakraborty

Bishawajit Chakraborty

I'm Bishawajit Chakraborty. Hello. I graduated from Rajshahi University of Engineering & Technology (RUET) with a degree in Mechanical Engineering. I'm working with ExcelDemy as a Content Developer for Excel & VBA. You can visit our website, Exceldemy if you'd like to read my published articles on MS Excel and VBA.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo