Hi
I need help trying to create a formula that will stop counting in B2 once I enter a date in C2 and want B2 to retain the count it stopped at.
Currently B2 is =TODAY()-A2
A B C
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Is anyone able to please assist me with this issue? I have read many blog post but was not able to locate any that did exactly what I needed.
I need help trying to create a formula that will stop counting in B2 once I enter a date in C2 and want B2 to retain the count it stopped at.
Currently B2 is =TODAY()-A2
A B C
Initial Notification Date | Days Unresolved | Date of Resolution |
9/30/2019 | 4 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Is anyone able to please assist me with this issue? I have read many blog post but was not able to locate any that did exactly what I needed.