Birthdays database

  • Thread starter Thread starter Doman
  • Start date Start date
D

Doman

How would one make a formula in Microsoft Excel for a
birthdays database that would be able to give the age of
a person by knowing the persons birthdate and birthyear
and of course today's date and year? Is there a way to
make this formula, and to make it so you can input either
the age or birthdate and birthyear and get the output of
the age or birthdate and birthyear?
 
Hi doman,

if you put the date you want in A1 and the following
formula in B1 will give a result like xx years, xx
months, xx days


=DATEDIF(A1,TODAY(),"Y") &" Year, "& DATEDIF(A1,TODAY
(),"ym")&" Months, " & DATEDIF(A1,TODAY(),"md") &" Days"


Abdul Salam
 
Thanks, I'll give that a try.

-----Original Message-----
Hi doman,

if you put the date you want in A1 and the following
formula in B1 will give a result like xx years, xx
months, xx days


=DATEDIF(A1,TODAY(),"Y") &" Year, "& DATEDIF(A1,TODAY
(),"ym")&" Months, " & DATEDIF(A1,TODAY(),"md") &" Days"


Abdul Salam


.
Click to expand...
 
Back
Top