• 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

    Hui...

  • 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]

papajohn22

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.
 

Hui

Excel Ninja
Staff member
assuming the date is in cell A1

=+DATE(YEAR(A1),MONTH(A1)+48,DAY(A1))
 

Hui

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
 
Top