How to add 3 to a time range and see if that past some action

HI guys,

I need to found a way to look to a data ID + contact date and add 3 or 7 day to this date and found if the Data ID have return into that range of time. I attach a document that will show what I need

thank you

I am not sure that I understand but perhaps the following formula will give you the results that you want:

Formula:

Please Login or Register  to view this content.

I suggest pasting the formula into cell E2 and then dragging the fill handle down to cell E9.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.