# How 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 different functions like MONTH, DATEDIF, YEARFRAC, andÂ YEAR. We’ll use the following sample dataset, where the D column is filled with today’s date.

## Method 1 – Using Formula with the MONTH Function to Count the Number of Months from a Date to Today in Excel

Steps:

• Select cell E5.
• Insert the following formula.
`=MONTH(D5)-MONTH(C5)`
• Press Enter.

• You will get the number of months for all the people in the data set.

## Method 2 – Applying the DATEDIF Function to Count the Number of Months from a Date to Today

Steps:

• Select cell E5 and use the following formula:
`=DATEDIF(C5,D5,"M")`
• Press Enter.

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

• You’ll get number of months between the joining date and todayâ€™s date in the data set.

## Method 3 – Inserting the YEARFRAC Function to Count Months from a Date to Today

Steps:

• Select cell E5.
• Insert 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, the INT function will convert the months into an integer value.

• Press Enter.

• Use the Fill Handle tool and drag it down from cell E5 to E13.

• Here are the results.

Read More:Â How to Calculate Years from Today in Excel

## Method 4 – Nesting YEAR and MONTH Functions to Count Months from a Date to Today

Steps:

• Use the following formula in cell E5.
`=(YEAR(D5)-YEAR(C5))*12+ MONTH(D5)-MONTH(C5)`
• Press Enter.

• Use the Fill Handle tool and drag it down from cell E5 to E13.

• Here are the results for our sample.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
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

Advanced Excel Exercises with Solutions PDF