Great as you stated it was a conflict between formulas. Thank you for your
time and help it is most appreciated.

Ron Coderre wrote:
That formula might be a problem because it returns decimal fractions of a
year.

Example:
E27: 06/18/1987
A27: 09/18/2007

This formula: =INT(A27-E27)/365.25
returns 20.2518822724162

So...even though that person is actually 20 years old...he will not be
picked up by your formula because he is "technically" older than 20.

Try using this age calculation:
=DATEDIF(E27,A27,"Y")
For instructions on using the UNdocumented DATEDIF function, see Chip
Pearson's website:
http://www.cpearson.com/excel/datedif.htm

Your formula, even if you'd constructed it more properly:
=INT((A27-E27)/365.25)
would still return some erroneous values.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

Hi the formula to obtain the value in F27:F48 is =INT(A27-E27)/365.25. Do
think this could be causing the conflict. if so what could be the
[quoted text clipped - 16 lines]

Chedd

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200709/1