Birthdays database

[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?

 

[Abdul Salam]

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

 

[Doman]

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


.