Birthdays database
 

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?

Birthdays database
 

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


-----Original Message-----
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?
.

Birthdays database
 

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


-----Original Message-----
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?
.

.