Excel - DateDiff Formula Not Displaying Correctly

[JcTon]

Using the following formula to calculate the age;

=DATEDIF(BirthDate,TODAY(),"y")&" years "&DATEDIF(BirthDate,TODAY(),"ym")&" months "&DATEDIF(BirthDate,TODAY(),"md")&" days"

Sometimes, the result displayed in the cell location within Excel is "days."

Any clue as to what is going on and how to resolve?

 

[JcTon]

Never mind.

I figured it out.

 

[onedtent]

would it not be a good idea to post your solution so people with similar problem may just search and find the answer?

_________________________________________________

 

[SkipVought]

I suppose it would depend on the value in Birthdate

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}