Help adding date to cell based of data in another cell

Hi Zachary.shupp,

I have no exact solution. But possible other options are:

- If you are maintaining separate sheet for each day, then please enter current date in a cell. Instead of Today(), we can use that cell.

- We may use a macro to get the date. There we can check whether the cell is already filled with a date. If not filled, we can take that row for processing.
For example:

Dim Counter As Integer
Dim CurrentValue As String

For Counter = 2 To 10
Range("D" & Counter).Select
If ActiveCell.Value = "" Then
CurrentValue = Range("B" & Counter).Value
If CurrentValue = "Mitigated" Or CurrentValue = "Escalated" Or CurrentValue = "Offline" Then
ActiveCell.Value = Now()
End If
End If
Next Counter

But we have to run the macro if any value changed in column B. Otherwise we cannot get correct result.