This seems like an obvious question.
I have a date column, and I want to create a formula to increase it by one month for each column.
10/2013, 11/2013, 12/2013, 1/2014, 2/2014, ...
How do you add one month to a date?
This seems like an obvious question. I have a date column, and I want to create a formula to increase it by one month for each column.
How do you add one month to a date? 





The currently favored answer will skip short months that follow long onesSet A1=20140131 Then the result using =DATE(YEAR(A1), MONTH(A1)+1, DAY(A1)) will be 20140303, thus skipping February. The EDATE approach suggested above loses daysShort months cause EDATE to drop days for successive months. E.g. =EDATE(DATE(2014,1,31),1) does produce 20140228, but applying it again results in 20140328, which is not the last day in March. A solution that does work: increment months with the day set to zeroSet the day to zero, and increment months, while being one month ahead. E.g. To start in January use DATE(2014,2,0) => 20140131 then DATE(2014,3,0) => 20140228, then DATE(2014,4,0) > 20140331 as one would expect by logically following the last day of each month. Other approachesAdjustments can be made if you want the last working day in the month, or 30 day increments while not skipping months, etc. Depends on the objective. 


As given in reference: Date Arithmetic, this adds one to the month:



I think you may need to use labels as dates are stored just as numbers which are then displayed in a format you choose. To add a month you'll need a complex calculation to determine how many days to take you to the next month. Hope I'm wrong and someone has an answer. 

