# Calculating Exact Ages

#### clftn2929

##### New Member
Hello All,

I am looking for a formula that calculates an individuals exact age given their date of birth. That shows just the age in years.

anyhelp would be greatly appreciated

Sincerely,

clftn2929

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Hi

Try
=(K12-K13)/365.25

where k12+k13 are formatted as dates and the cell in which the formula is in is formatted as a number
k12 = todays date
k13 = DOB

Hope this is OK

Neill

clftn2929 said:
Hello All,

I am looking for a formula that calculates an individuals exact age given their date of birth. That shows just the age in years.

anyhelp would be greatly appreciated

Sincerely,

clftn2929
this will tell you exactly how old somebody is:
="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"
c8 = birthday
this will tell you just years:
="Age is "&DATEDIF(C8,TODAY(),"y")&" Years
c8 = birthday

taken from Phantom1975's xlfdic.xls (a must have for newbies! - like me )

edit: must add " to end of second formula, oops

Neil,

I can't thank you enough for your info. You have saved my butt. thanx again.

sincerely,

2929

thank you very much Zack

Hi, Firefytr -

Greetings from Salem.

Not being a proud guy here :wink: , I'm wondering where/how I could access Phantom's Xlfdic.xls?

Thanks,

Golf

http://homepage.ntlworld.com/noneley/

go to this link, the zip file is in the upper left hand corner of the screen.

great tool, love it myself.

and hello from boardman!! nice to hear from one so close!

Thanks, Zack ---

I loaded it up at work, and it does work great. Planning on loading it at home tonight.

Try to stay warm and DRY!!!!

Take care,

Golf

anytime.

and i'm staying dry, just not warm.
wait... wait... heeerrreee we go!!!

:wink:

Replies
6
Views
119
Replies
1
Views
370
Replies
3
Views
182
Replies
7
Views
208
Replies
8
Views
276

1,202,911
Messages
6,052,517
Members
444,588
Latest member
ViJN

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back