Getting 106 for Birthday Formula

  • Thread starter Thread starter doblesb
  • Start date Start date
D

doblesb

I have created a form in excel which has a place for the person's date
of birth(DOB). When I enter the DOB the year shows up in the "age"
space. I am using the formula, =DATEDIF(E6, NOW(),"y")&"", in the "age"
space to create the correct age.

Here's my problem, when I do not have a DOB the number 106 shows up in
the "age" space. How can I stop this from happening?

Thanks in advance,

Steve
 
Put your formula in an IF statement, as in:

=if(e6="","",datedif(e6,now(),"y"))

Does this help?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering Days360 in Table formula 2
date of birth or blank cell? 3
Calculate age 3
Birthday stuff 21
Leave cell blank if no data 3
Calculating Age NOT as of today but as of a date in the future or 3
date formulas 9
Error message needed if incorrect Date Of Birth (DOB) entered 4

Back
Top