Stactic Time Stamp based on Formula being True

[chells_free]

I am trying to have my excel give back a timestamp that will not update once a formula is deamed true for the first time.

The formula is based on cells in the column and if the number is greater than or equal to 46, the if statement returns "X" in column V, if not it remains blank. Once the formula returns an "X" I need a the respective cell in column "W" to give me a date that wont change if the next time I open the workbook and with the new data being entered into the same data range is less than 46 and therfore returning a blank in column V.

This workbook is an on going and used once a week. The goal is to track each time the amount is over 46 without having to manually enter the dates.

Please help as soon as possible. I'm needing this active by this saturday.

 

[rollis13]

This for sure would be the quickest way to do it before saturday: LINK

 

[chells_free]

This for sure would be the quickest way to do it before saturday: LINK

Thank you for sending me that link. I have tried using those funtions, although week-to-week I need the date to stay even though the data changes. Using the static control keys become combersome when, multiple people enter the data.

I was hoping to set a vba to have everything set.

 

[rollis13]

Have a try with this macro to be pasted in a standard module and launched when needed. Since no dummy data is available, I guessed; eventually you can adapt it to your needs.

Option Explicit
Sub Check_FH()
    Dim cell   As Range
    Dim cRow   As Long
    For Each cell In Range("N3:N9")               '<- adjust range as needed
        cRow = cell.Row
        If cell.Value >= 46 Then
            Cells(cRow, "V") = "X"
            Cells(cRow, "W") = Date               'insert date
        Else
            Cells(cRow, "V") = ""
            If Not Cells(cRow, "W") = "" Then Cells(cRow, "W") = Date 'update date
        End If
    Next cell
    MsgBox "Done!"
End Sub