I used the following formula to compute the DOB in order to not have to use
multiple cells.

=DATEDIF(C5,NOW(),"y") where C5 has DOB and formula is in D5

The problem with this is that if nothing is entered in C5 then it gives me a
solution of 106 instead of leaving it blank. What am I doing wrong here?

"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.