Formula problem

G

GVegas

I have the following formula to calculate a persons age based on todays date
in one column and their DOB in another, but I need to modify the formula so
if no DOB is listed, the formula returns a blank. Currently a blank in the
DOB column calculates to 108.

=DATEDIF(M2,K2,"Y")
I need to add something to this so I get a blank, not 108.

HELP!!!

Thanks
 
B

Bob Phillips

=IF(OR(M2="",K2=""),"",DATEDIF(M2,K2,"Y"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Error message needed if incorrect Date Of Birth (DOB) entered 4
retrieving multiple corresponding values with variable rows/column 4
Help w/simple Date Formula please 4
How to stop index match returning data where lookup cell empty 4
formula to automatically calculate customer age 1
Birthday stuff 21
Calcing DOB 4
Formula to Calculate Age 2

Top