How.com.vn is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 22 people, some anonymous, worked to edit and improve it over time.
This article has been viewed 331,406 times.
Learn more...
Microsoft Excel is a powerful program. If you are using it for a calendar or anything else where you might need to find the date exactly 1, 2, or 3 months after another date here is a formula you can use.
Things You Should Know
- The DATE function makes it easy to increment dates by days, months, or years.
- When editing a formula with the DATE function, you can simply add +1 to the month.
- You can also use the EDATE function to increase the date by one month.
Steps
- Turn on your computer and open a new or existing Excel spreadsheet.
- In any cell, for this example we will use A2, type in you date. Ex. 1/1/2006Advertisement
- In a different cell, for this example we used B2, type in the amount of months cell A2 is to be incremented by. Ex. 5
- In the last cell type the formula:
=DATE(YEAR(A2),MONTH(A2)+B2,MIN(DAY(A2),DAY(DATE(YEAR(A2),MONTH(A2)+B2+1,0))))replacing what is in bold with the appropriate cells for your spreadsheet. - You will see that this cell now has the calculation desired.
- Another option is to use =EDATE(start_date,months)
This is a simpler method but can only be used if the Analysis ToolPak add-in is installed.
Expert Q&A
Video
Tips
- Calculating the Day is complicated due to the varying 30 and 31 day months. This formula will take a date like 10/31/2006 and add 1 month to become 11/30/2006. Whereas, a more simple formula without the MIN function may give the incorrect date of 12/1/2006.Thanks
About This Article
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.