find out specific month and year

[via135]

Hi

I am having Jan-2013 (month & year only) in cell A1. What I want is the month and year after certain number of months let us say 6 months in B1 (Jul-2013). What formula should I use in B1? Help please.! - via135

 

[joeu2004]

I am having Jan-2013 (month & year only) in cell A1.
What I want is the month and year after certain number
of months let us say 6 months in B1 (Jul-2013).
What formula should I use in B1?

First, I hope you should have an actual date in A1. You might have already,
if Excel recognizes Jan-2013 as a date. Does ISNUMBER(A1) return TRUE?

If so, simply format A1 as Custom mmm-yyyy.

Then B1 would be the formula =EDATE(A1,6), formatted as Custom mmm-yyyy.