Hello. Excel 2007.
Has someone got a reliable formula that will add a number of months (precisely) to a date? (Without VBA?)
I don't just want to add 90 days for 3 months..
Thanks, Andy.
Add months to date
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Add months to date
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78585
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Add months to date
The EDATE function is built into Excel 2007 (in earlier versions, it was part of the Analysis ToolPak add-in).
Its syntax is =EDATE(date,months)
For example, with a date in A1, the formula to return the date 3 months later is
=EDATE(A1,3)
If you use a negative number for months, the result is the specified number of months before the date.
Its syntax is =EDATE(date,months)
For example, with a date in A1, the formula to return the date 3 months later is
=EDATE(A1,3)
If you use a negative number for months, the result is the specified number of months before the date.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Add months to date
Thank you.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.