Adding 3 months-

[thursday140]

Good morning,

Currently I have a sheet with hundreds of entries, and I need to add 3 months to the months in Column A.
In Column A I have January, February etc.. I need to add 3 months in Column B using column A. Example: A1 January, B1 April
A2 June, B2 September. There's no particular order all I want to do is add 3 months to the month that's showing in column A. etc..
Sorry for any confusion.



Any help is helpful!

Thank you,

[samba_ravi]

do you have dates OR text (month) in column A

[63falcondude]

If the months in column A are actual dates, you can use the EDATE function: =EDATE(A2,3).

If the months in column A are text, try this:

=TEXT(EDATE((A2&1)+0,3),"mmmm")

[thursday140]

do you have dates OR text (month) in column A

I have months listed.

[63falcondude]

Happy to help. Thanks for the rep!

[Jeff Ho]

@63falcondude, may I ask what the purpose of the red text is in your formula?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

seems to work the same. The only difference I see is that the first one returns an actual date of 9/11/1984 and the second returns 9/10/2018 (in my test of A2 = 6/10/2018).

- Jeff

[63falcondude]

Sure Jeff.

The OP has only the month name in the cell so =TEXT(EDATE(A2,3),"mmmm") would not work. That would only work if there was an actual date in A2.

Let's say that A2 is January. A2&1 returns January1. Adding 0 to this converts January1 into an actual date (1/1/2018).

[Jeff Ho]

Beautiful! Thanks! I had tried to solve it by assuming or converting to dates in col A ... then forgot he hadn't specified originally, so I tested your formula on my example.

Have a rep for reminding me to think more clearly and showing me how to convert text to date without a macro!

- Jeff