Adding Months

TimmiAndrew · #1 09-16-2015, 09:03 AM

Col A has a date in the format mmm/yy. Col 3 has a digit for the number of months. I want to add Aug-15 + 8 so Col H shows Apr-16.

I tried adding them together but the result is also Aug 15, I think because it added 8 days instead of 8 months.

Can I get it to add months together

trainingclc · #2 09-16-2015, 10:11 AM

=date(year(a1),month(a1)+c1,)

gebobs · #3 09-16-2015, 10:21 AM

EDATE is precisely the function you want. It returns the date for the specified number of months after a specified date.

Code:

=EDATE(A1,8)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
showing months in another duration column	ketanco	Project	8	01-20-2015 07:27 AM
entering duration in months	ketanco	Project	1	12-17-2014 01:09 PM
Adding months to a Date	tsindos	Word	4	10-04-2011 11:20 PM
chart with months	windseaker	Excel	1	04-29-2011 11:45 PM
Setting up recurring months to skip some months etc.	dwelch@ykfireprevention.c	Outlook	0	11-30-2010 10:15 AM