right i got what you mean now but it only returns a positive result if its seven days from the day the person was born eg:

10/05/1988 todays date
16/06/1988 date of birth
this works


10/05/2012 todays date
16/05/1988 date of birth
doesnt work and this is what i need to work lol


any ideas? thanks for you help