Help with formula to stop counting days when a value is entered into another cell

Occasional Contributor

Help with formula to stop counting days when a value is entered into another cell

This is my first time to ask a question so hopefully I am explaining my question correctly.

I have an IF statement that counts down days based on a start date (L) and target date (BE) that is dependent on whether or not a date is entered into (AB).  The target date (BE) is based on a specified number of days in (BC) added to the start date (L).

Below is my formula that is in (BD)...

=IF(AB2="",BE2-TODAY(),AB2-L2)

The AB2-L2 is the part of the formula i want to change but don't know how.

Once a date is entered into (AB), I would like (BD) to show the difference between the number of days in (BC) and the actual number of days it took to get to the target date (BE).  My current formula shows the actual number of days in (BD) but then you have to manually compare the days shown in (BC) and (BD).

4 Replies

Re: Help with formula to stop counting days when a value is entered into another cell

Attached a file with a simplified example that may contain the answer to your question. If not, please provide n example where you indicate what values you expect to see in a given situation.

Re: Help with formula to stop counting days when a value is entered into another cell

Thanks for the help.

If the actual # of days go beyond the target number, how do I get those to show as a negative number?

Re: Help with formula to stop counting days when a value is entered into another cell

Simplified the formula a bit. See attached. Is that what you mean?

Re: Help with formula to stop counting days when a value is entered into another cell

Yes...thanks for the help!