I'm a rookie when it comes to Excel, but I need help & fast!

Can anyone help me figure out how to do this:

I have several thousand names with birthdates in a spreadsheet, and I'd like to find an easy way to see how the ages breakdown.

I only need year, but day would extra cool. So a forumla that would take today's date and subtract the birthdate to show "current age".

The other thing I need to do with the data is determine when each listing will reach a threshold age, lets say 65. So I'd need a formula to take the birthdate and add 65 years to show a date.

It sounds easy but the formatting with the dates has me pretty lost.

Any ideas?


Thanks!


EDIT: an afterthought, with the ages, is it possible in excel give a sum of how many people are 35, how many are 36, etc....?

 

make a new column. in that column (B for example), type in "=YEAR(A1)" where A is the column with the date. Do that for every row.

Now you have just the year.

 

Birthday cell a1 contains 1/1/2001


----------------------------------------------------------
b1 =NOW() <- this gives you todays date and time 7/19/2005 11:37

c1 =DAYS360(A1,B1) < ("refertothebirthdatecell","refertothenowcell") this will give you the number of days that have past since now and the birthdate 1638

d1 =C1/360 <divide the days360 cell by 360.this is the number of years (it ain't perfect doesn't take into account leap years)4.55

---you can compress these steps =DAYS360(A1,NOW())/360------





e1 =INT(D1) <- int("refertothedays360cell") this will give you the persons true age






----------------------------------------
f1=D1-E1<this gives you multiplier needed to find how many months

g1=F1*12 <--will get you the months lived.

---you can compress these steps----=(D1-E1)*12


More info PM me

 

^^^ Damn, you're good!

 

maybe he should change his name to "excelsinexcel"

 

 

Excel is my occupation. I was rated one of the top Five excel developers for over a year (before I stopped participating) For a while I was number 1 (seven months) I'm not as good as jay walkenback or steven bullen but I've ran with them. This question wasn't a very good opportunity to show off. I love this stuff so if you have something really complex and I have time I'll do it free of charge (well at least I'll give you the first iteration). I create simulators that predict share of preference for major pharmacutical companies. Lots of stats, VBA programming and excel work. If any of you need a hand PM me when I have the time I'll help. That's why I quit participating, when my work load is heavy I just can't get to it. However right now my company is paying me to not work for the competition until they beef up their quant work, so I often have plenty of time on my hands. Oh yeah even if I think your conspiracy theorys are crazy josh I'd stil love to give you a hand!

 

 

I don't know what to say except, WOW!

Please check your PM & thanks again.

Cheers

 

[QUOTE=exceltoexcel,Jul 19 2005, 07:49 AM]Birthday cell a1 contains