1. ## Adding time using months (Office 2003 (SP2))

Hello there!
Once again I'm stuck with excel. I have a spreadsheet containing several names of employees including their date of employment. For instance Mr. Smith started working of 12th March 2000, Mr. Summers started @ 21st November 1998, aso.
In a second column I insert a period of time (in months), say 4. In the third column I would need the exact date resulting this function. Is there a formula available in excel which can do the trick? (12th March 2000 + 4 months= ?) <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

Help appreciated!

2. ## Re: Adding time using months (Office 2003 (SP2))

Philipp:

Assuming cell A1 has the start date (e.g. 12 March 2000) and B1 has the months to add (4 in your example) then the formula: =DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)) in C1 will give you 12 July 2000 as a date, which of course can be formatted as you wish. The formula can then be copied down the column.

Regards,

Tony.

3. ## Re: Adding time using months (Office 2003 (SP2))

Make sure that Analysis ToolPak is installed (in Tools | Add-Ins...). This add-in has a function EDATE that does exactly what you want. With the employment date in A2 and the number of months in B2, the formula

=EDATE(A2,B2)

will return the date B2 months after the date in A2. (If B2 is negative, the date returned is before the date in A2). You'll probably have to format the result as a date.

4. ## Re: Adding time using months (Office 2003 (SP2))

Hi fellows!

Thanks for your help. It worked just perfect!
<img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•