• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding months to a date [SOLVED]


New Member
I have just found this forum and wonder if anyone can help me with this problem.

I have a date eg 12/9/2009. I need to add a number of months to this date eg 24 or 48 or 36 and show the answer as Sep-11.


Excel Ninja
Staff member
assuming the date is in cell A1



Excel Ninja
Staff member
and to change the date format

right click on the cell and select Format Cells

In the Format Cells dialogue select the Number Tab and Custom in the Category box

in the Type box put mmm-dd