find out specific month and year

  • Thread starter Thread starter via135
  • Start date Start date
V

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
 
via135 said:
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?
Click to expand...

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.
 
Back
Top