This article outlines how to add months to a date in Excel
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
In Excel, you can add a number of months to a date using the EDATE function. This can be very useful when performing financial modeling and you are adjusting time periods. This is a step by step guide on how to have Excel Add Months to Date.
For example, if you want to have a monthly financial model, you can add one month to the start date. If you want a quarterly financial model, you can add 3 months to the start date.
Thank you for reading CFI’s step by step guide to learning how to add months in Excel. As mentioned above, this is a very common practice in financial modeling and a very useful formula for financial analysts. The best way to become a master at Excel is by practicing… a lot.
To get more practice, check out these additional CFI self-study guides which will show you how to perform advanced functions and formulas:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.