If I understand what you're asking, try this in D2:

=IF(AND(DATE(YEAR(B2)+5,MONTH(B2),DAY(B2))<=D1,DAT E(YEAR(C2)+62,MONTH(C2),DAY(C2))<=D1),"B2="&TEXT(B 2,"m-d-y")&"
& C2="&TEXT(C2,"m-d-y"),"")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Amanda" wrote in message
...
I would appreciate any help you could give. I'm going to try to explain
this.

In D2, I need to know if these two conditions - B2 is 5 years or more from
D1, and C2 is 62 years or more from D1 - are met. If so, I need to know
what
date both of those conditions were met, otherwise leave blank.

Thanks
Amanda