Format dates & add ten years to date

J

Jason K

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
 
J

Jim Thomlinson

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top