Dates

[Rajaa S.]

Hello,
I have a sheet with dates in this format:
20080910
1st: I tried to change the date format & tried most of formats but wasn't able to change it to become something like this: 05/22/08.
Then what I need is to create a formula to calculate how many years till today has passed since that day.
Could I get help formating that date to a proper one & creating that fomula to calculate the date.

Thank you,

[mudraker]

To convert to date format

Select column or range of data with dates
Data Menu
Text to Columns
Delimited
Remove all Ticks from option boxes
Next button
Select Date
Select format YMD or YDM (not sure what the format is from your posted example)
Finish Button

For the calculation habe a look at
http://www.cpearson.com/excel/datedif.aspx

[Rajaa S.]

Thanks for your help, but didn't work as u suggested. But i'm glad to learn this option. Delimited was already selected. & this is how my dates looked:
20010402
20070319
19960619
20011015

I need to convert them to this format: mm/dd/yyyy, then I will try the next step & finding the calculation for the date formula you suggested. I hope i'm more clear now.
I appreciate any help I get.

Thanks.

[shg]

I copied your data, did exactly what mudraker explained, and it worked fine.

[martindwilson]

19960619 is obviously 1996 06 19
therfore do as mudraker says use
ymd
you should then see it in the format
19/06/1996
to change that to 06/09/1996 custom format cells as mm/dd/yyyy

[Rajaa S.]

Thank you Mudraker very much for all the hep. I tried again & it worked. :