Age Calculation

  • Thread starter Thread starter Muntasar
  • Start date Start date
M

Muntasar

Hi,
Is it possible to calculate age in an excel sheet? How?

My friends birthday is 17-09-1970, today is 25-08-2003.
Today how old is he?

Thanks
 
A1= 17/09/1970
B1= 25/08/2003
C1=DATEDIF(A1,B1,"y")
The third argument of the function is the time unit you want to calculate (y
= years, m=months, d=days ...)
 
Try
a1=17/09/1970
B1 =DATEDIF(A1,NOW( ),"y") & " years, " & DATEDIF(A1,NOW( ),"ym") & "
months, "& DATEDIF(A1,NOW( ),"md") & " days"

Bryan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Age to Months 3
Calculate age 13
How to calculate Age 4
Calculate age 3
Calculating an age from 2 dates 4
Calculating average ages 5
excel formula sumproduct and age ranges 3
date of birth age formula 8

Back
Top