Stop counting day if another cell is populated

[AHUETE]

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[TABLE="width: 330"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Initial Notification Date[/TD]
[TD]Days Unresolved[/TD]
[TD]Date of Resolution[/TD]
[/TR]
[TR]
[TD]9/30/2019[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.

 

[Joe4]

Welcome to the Board!

The only way I know how to do that is with VBA.

Right-click on the sheet tab name at the bottom of the screen, select "View Code", and paste this VBA code in the resulting VB Editor window:

Private Sub Worksheet_Change(ByVal Target As Range)

'   See if cell C2 updated
    If Not Intersect(Target, Range("C2")) Is Nothing Then
        If Range("C2") <> "" Then
            Range("B2").Value = Range("B2").Value
        End If
     End If
     
End Sub

This will automatically hard-code the value in cell B2 as you add an entry into cell C2.