Format dates & add ten years to date
 

I imported a report into excel, in the report the effective dates are
yearmonthday (20090815). I would like to change these to a normal date
format. I also need to in a seperate column show the date with ten years
added, also if as of this month the effective date is within ten years or
outside ten years.

Any help would be greatly appreciated

Format dates & add ten years to date
 

Assuming your date is in A1 here is one way. This converts that number into a
normal XL date...

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

to add 10 years

=DATE(LEFT(A1,4) + 10,MID(A1,5,2),RIGHT(A1,2))

I don't understand the last part of the question?
--
HTH...

Jim Thomlinson


"Jason K" wrote:

I imported a report into excel, in the report the effective dates are
yearmonthday (20090815). I would like to change these to a normal date
format. I also need to in a seperate column show the date with ten years
added, also if as of this month the effective date is within ten years or
outside ten years.

Any help would be greatly appreciated