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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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
79
Joe4
Joe4
M
  • Question
Aging buckets By customer account aging report
Replies
2
Views
114
Alex Blakenburg
A
S
  • Solved
add a message box if a match using a userform list box doesn't match
Replies
7
Views
167
still learning
S
A
  • Question
Calendar issue trying to get holidays and birthdays to update
Replies
7
Views
213
awoohaw
awoohaw
I
  • Solved
Average age of top 10 in the list using pivot table
Replies
4
Views
176
awoohaw
awoohaw

Forum statistics

Threads
1,215,418
Messages
6,124,793
Members
449,189
Latest member
kristinh

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