Works Great, can it be modified to show 25 in A3 if B16 is greater than 30.

"daddylonglegs" wrote:


If column I shows just numbers, e.g. 7 (not "7 years")

In A3

=VLOOKUP(DATEDIF(B16,TODAY(),"Y"),I:J,2,0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515134