#1
|
|||
|
|||
Adding Months
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 |
#2
|
|||
|
|||
=date(year(a1),month(a1)+c1,)
|
#3
|
|||
|
|||
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) |
|
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 |