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"),"")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Dax Arroway" wrote:

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
--
I would give my left hand to be ambidextrous!


"Marcelo" wrote:

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:

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.
--
I would give my left hand to be ambidextrous!