time

[mickdodge]

i have a "IF" statement that if satisfied will enter in today's date and time. problem is that the time is volatile and keeps getting updated whenever there is a change to the spreadsheet anywhere. how do i format the time so that it doesn't continuously update?

 

[lenze]

You really can't with a function. You will need VBA to do this. Post your IF statement so we can see its dependent(s) and possibly code off of them.

lenze

 

[mickdodge]

=IF(B162="","",NOW())

basically if B162 (in this case) has a name entered, A162 will populate date and time.

 

[lenze]

Just B162 or all of column "B"

lenze

 

[mickdodge]

All of Column B and all of column A. as B gets populated, it will populate A.

 

[lenze]

Place this in the WorkSheet module. Right click on the sheet tab and choose "View Code" Paste in the white panel.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column <> 2 Then Exit Sub
Cells(Target.Row, 1) = Date 'Change to Now for Date and Time
End Sub

This will place date (and time?) in column "A" when a value is entered OR changed in Column "B"

HTH
BTW: Welcome to the board!!!
lenze