Average Age from Download??

**Roger Smid** · 02-13-2012, 05:04 PM

I am trying to find the average age from a downloaded group. The format of the birthdate is yyyymmdd.
For example:
A1: 20020101
A2: 20010101
A3: 19990101

If I convert the file using =Date(mid(A1,1,4),MID(A1,5,2),MID(A1,7,2)) the dates are as follows:
B1: 01/01/2002
B2: 01/01/2001
B3: 01/01/1999

I used the formula =DATEDIF(AVERAGE(B1:B3),TODAY(),"y") this results in a #value! error. I know it has something to do with the original download. Any help is appreciated.
Thanks

**daddylonglegs** · 02-13-2012, 05:21 PM

That works for me - as long as your conversion formula returns valid dates then the DATEDIF function should work OK

**Roger Smid** · 02-13-2012, 05:47 PM

I don't konw what I am doing wrong, it is still giving me a #value! error. The original downloaded file is in a table, would that have anything to do with my problem??

**daddylonglegs** · 02-13-2012, 05:52 PM

I assume you have more than the 3 dates shown in your example - are you sure the conversion formula is working for all the dates? Can you attach the file or the relevant part(s)?

**Roger Smid** · 02-13-2012, 06:04 PM

I GOT IT! After reviewing everything for the 5th time, I sorted the file thinking there may be one of 7,000 files entered incorrectly causing my formulas to fail. There was one! Now It works. Thank you for your time it was huge a help because it confirmed what I was trying/doing.