date of birth or blank cell?

K

KrisP

Hello,
this may sound simple, but i have a date of birth in one cell, I want to
show the age or a blank cell if empty (no dob) next to it. What formula
would i use?
Many thanks in advance!
K
 
J

Jacob Skaria

With DOB in cell A1 try the below

=IF(A1="","No DOB",DATEDIF(A1,TODAY(),"y")&" years")
 
R

rebecca

Hey,

I have trying to find a formula to do this for ages, however i need a
formula that will do the excact amount of time. ie for a child who is not
yet 1 years of age. and still leave spaces where3 there is no date in the DOB
colum.

Can you help with this?
 

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

date formulas 10
How do I calculate a person's age from date of birth and a date 4
Entering Days360 in Table formula 2
How To Have A Cell Be Blank If... 2
Calculating age from date of birth and ignoring if blank 3
Calculate age 3
Constant date in one cell 1
Help with if statement 4

Top