how to calculate the age

J

jgoc

New Member
Joined
Dec 12, 2003
Messages
6
hi everyone!!
I need to get the age of a list of persons, but the only thing that I got is their birthday, I will like to know if there is a formula to get the age at this day using their birthday!!
Thank you in advanced :)
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Sort by date Sort by votes
from Phantom1975's xlfdic01.xls file:

="Age is "&DATEDIF(D34,TODAY(),"y")&" Years, "&DATEDIF(D34,TODAY(),"ym")&" Months and "&DATEDIF(D34,TODAY(),"md")&" Days"

where D34 houses birthday

HTH
 
Upvote 0
You must log in or register to reply here.

Similar threads

I
  • Solved
Age as of a certain date based on birthday
Replies
3
Views
48
Joe4
Joe4
M
  • Question
Aging buckets By customer account aging report
Replies
2
Views
73
Alex Blakenburg
A
S
  • Solved
add a message box if a match using a userform list box doesn't match
Replies
7
Views
125
still learning
S
A
  • Question
Calendar issue trying to get holidays and birthdays to update
Replies
7
Views
194
awoohaw
awoohaw
I
  • Solved
Average age of top 10 in the list using pivot table
Replies
4
Views
156
awoohaw
awoohaw

Forum statistics

Threads
1,214,791
Messages
6,121,611
Members
449,038
Latest member
apwr

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top