Jan 21 2020 11:01 AM
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).
Jan 21 2020 12:48 PM
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.
Jan 21 2020 01:20 PM
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?
Jan 21 2020 10:44 PM
Simplified the formula a bit. See attached. Is that what you mean?
Jan 22 2020 04:58 AM
Yes...thanks for the help!