Mark,

Let's assume that the customer data is structured name in column A, DoB in
column B, then the date tests are


=IF(AND(G9="R18",DATE(YEAR(TODAY())-18,MONTH(TODAY()),DAY(TODAY()))<VLOOKUP(
J9,'Customer'!A1:B100,2,FALSE),"Ok","Reject")

and


=IF(AND(G9="R15",DATE(YEAR(TODAY())-15,MONTH(TODAY()),DAY(TODAY()))<VLOOKUP(
J9,'Customer'!A1:B100,2,FALSE),"Ok","Reject")

Best way would be to have coilumns with intermeditae resluts and then test
these on the master sheet.

If you want to send me the workbook, I'll take a look for you.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark1ace1 " wrote in message
...
I tried that, but the age returns 12/01/00, and not sure how to add the
IF statement...:( I tried to do a VBA but was not sure how to list one
column...doing my head in ...
Mark


---
Message posted from http://www.ExcelForum.com/