Count months between dates in excel

July 22, 2022
562 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

Finding the length of a period of time is fairly easy to do in excel. You can just add some dates onto your spreadsheet and you'll have your answer right there. However, counting months between dates isn't quite as simple. There's no easy way to enter in two dates and get back out an accurate amount of months between them. Time is a tricky thing to count in Excel because it's not just one number. The amount of time between two dates can vary based on how far apart those dates are, how many days/weeks/months there are in between them, and what month or season it is when you're calculating the gap. In order to calculate the correct amount of months between two dates, you need to take all these factors into account first before running any formulas or calculations on them. This tutorial shows how you can easily count months between dates in excel using formulas.

How to count months between dates in excel using DATEDIF function

This method works best with versions 2016/2016/mac/online.

  1. Now we are going to use a table to show you the usage of this function to count months between dates in excel. This table records the entry date of the company’s employees. Now we want to calculate the employee’s year of service. To do so, we must first click cell C2 and then click Insert Function by pressing The Insert Function Key on keyboard or clicking on the Insert Function button on toolbar.

  1. Then click on DATEDIF in the Select a Function box that appears and click OK. The Function Arguments dialog box will pop up automatically.

3.The start date is the date we want to begin calculating, which corresponds to the employment dates in column B of the table. Click on cell B2 here.

4. The end date is the deadline, which is April 27, 2020 at right side of the table. Click cell D2 then press F4 to add an absolute reference and lock the end date calculation location. Please notice that this should be greater than start date.

5. A Comparative Unit is the type of information returned by a function. In this case, the required information is represented by three parameters: Years (Y), Months(M) and Days(D). Remember to add double quotes when entering parameters. Enter Years here;

6. Then click enter and the number of months between the start date and end date will show up in the selected cell.

How to count Years between dates in excel using DATEDIF function

This method works best with versions 2016/2016/mac/online

1. Repeat the same process as explained above to count months between dates in excel and just replaceM with Y.

2. Now press OK and the number of years between the start and end dates will appear in the cell.

How to count Days between dates in excel using DATEDIF function

This method works best with versions 2016/2016/mac/online

1. Repeat the same process as explained above to count months between dates in excel and just replaceM with D.

2. Now press OK and the number of days between the start and end dates will appear in the cell.

Did you learn about count months between dates in excel? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides.

You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.