Formula to compute someone's age if you enter their B-day
First, thank you very much for the formula.
Second, how can I set up a condition formula using this formula so that the
cell will be yellow 5 days prior to their birthday and red up to 5 days after
their birthday.
"Gary''s Student" wrote:
=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &
DATEDIF(A1,A2,"md") & " days"
if the birthday is in A1
--
Gary's Student
"Millerk" wrote:
I'm trying to find out the formula that will allow someone to enter a child's
birthday in one cell and another cell will compute their age.
|