Time Difference Formula

In the D column I have a start date, in the E column I have a 30 day re contact date, in the F column I have a formula to tell me how many days I have until I recontact. I have added another column at the end as the Response Received Date.

My question is when I enter the response received date how I do I stop the counting of the days until recontact? Do I do it in the conditional formatting or the the actual Response received column?

I've tried already a few different suggestions but haven't been able to get anything to work.

Hello

It seems like you need an IF formula combined with the formula in Col F.
Say your Response received Date is in Col G then something like this could be added to your Col F formula; =IF(G2="",your formula,""). That would then leave nothing in the Col F cell if the adjacent cell had a value in it.
If you could post your formula thats in Col F we could work it out for you.

nika

Hi
How about:
assuming G1 is your response date column
=IF(G1="",your counting formula,"Contacted")

If G1 is empty your formula will keep counting, if G1 is not empty then the word "Contaced" will appear.

or
=IF(G1="",your counting formula,G1-D1)

HTH
JG