Help w/simple Date Formula please

[Dax Arroway]

I've got two columns (D, E) headed DOB and Age. Basically what I'm looking
for is a forumula which looks at D, puts the amount of years in E as in:
=DATEDIF(D210,TODAY(),"y")
but not display anything if D is blank.

What I came up with is:
=IF(D2="","",(DATEDIF(D2,TODAY(),"y")))
but that doesn't seem quite right. It works but Excel says there's an error
in it.

Any help please?
Thanks in advance.
--D.

 

[Pecoflyer]

Hi,

I don't understand your sentence "It works but Excel says there's an
error
in it."

Which error do you get, and what works?

I've got two columns (D, E) headed DOB and Age. Basically what I'm
looking
for is a forumula which looks at D, puts the amount of years in E as
in:
=DATEDIF(D210,TODAY(),"y")
but not display anything if D is blank.

What I came up with is:
=IF(D2="","",(DATEDIF(D2,TODAY(),"y")))
but that doesn't seem quite right. It works but Excel says there's an
error
in it.

Any help please?
Thanks in advance.
--D.

 

[Dax Arroway]

A green little tab shows up in the top right corner of the cell and says that
there's an error in the formula. I can ignore it but I'm not sure what I'm
ignoring and I'm not Excel savvy enough to know if my formula is right or
not. It seems OK but Excel is telling me there's an error. I don't know why
and I'm hoping somone might be able to tell me.

I would give my left hand to be ambidextrous!

 

[Marcelo]

There is no error on your formula,

what is the mesage excel is given?


--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Dax Arroway" escreveu:

 

[Dax Arroway]

When I mouse over the flagged cell there's a bubble which says, "The formula
in this cell differs from the formulas in this area of this spreadsheet."
When I click the exclamation pointed yellow warning sign it says,
"Inconsistant formula."

Maybe someone formatted the cells as number instead of leaving it at
General.

....actually, I reformatted all the cells in that column and all the green
flags went away. I'm guessing that was it. Thanks for taking a look at this
and reasuring my formula. --Dax

 

[David Biddulph]

No problem with that formula, but you could lose one pair of parentheses:
=IF(D2="","",DATEDIF(D2,TODAY(),"y"))
What error message do you get from Excel?

 

[Shane Devenshire]

Hi,

The error "warning" is part of Excel Error Checking options, it often tells
you there "May be" and error.

You can simplify your formula to read:

=IF(D2,DATEDIF(D2,NOW(),"y"),"")