I'm not sure I understand your question but if the value is a date say you
call it bday then bday + 7 would be 7 days later or bday - 30 would be 30
days earlier.

I don't know if that helps at all.

David

"jenna" wrote:


I have a table column A to colimn E of data, this is what i have in mind

First see if A15=A16 and B15=B16, if yes created two variable; bdate and
adate, bdate will be 30days before c15 which contains date whiles a date is
30 after C15, compare this to c16, if c16 is between bdate or adate then go
to F16 and enter e16.

If any of the above is false, go to the next row and repeat the prcess.

Any help is appreciated

thanks