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 ten filter 2
Adding 10 years to a date 2
Date Format and Sumproduct 9
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
Date function within loan amortization spreadsheets 3
add to date 1
Run report on the 5th of every month automatically 0
Convert Date to MMYY format 2

Top