This article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 8,364 times.
If you have a start date and end date entered in Excel, you can calculate the days, weeks, months, and years between the two. This How.com.vn will show you how you can count the months between two dates using the "DATEDIF" function.
Steps
Open your document in Excel. You can either open your document from within Excel by going to File > Open or you can right-click on the file in your file browser, select Open With and then Excel.- Make sure you open a file with two dates in separate cells.
Click a blank cell to be your results cell. The results of the formula you'll be entering will appear in this cell.- For example, if you have dates in columns D and E, you'll most likely want to add your results to column F.
Enter the following formula: "=DATEDIF(D5,E5,"m")".- In this example, D5 is the cell with your start date and E5 is the end date. Change these two cell addresses to the correct ones for your data.
- In this example, m returns the number of full months between the two dates. If you want to see months and days, use md instead.[1]
Press ↵ Enter or ⏎ Return to run the formula. The results of the formula will appear in the cell.Advertisement
Expert Q&A
References
About this article
1. Open your document in Excel.
2. Select a blank cell to be your results cell.
3. Enter the following formula: "=DATEDIF(D5,E5,"m")".
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
