The cell holding the Date is C4 (it looks at C3, IF(C3 0, ...date..., " ")).

This would be for cells in Rows 4, 6, 8, 10, & 12; Columns C thru G, looking
at the cell directly above. -Thx!
--
FirstVette52


"Mike H" wrote:

Hi,

This works for C3 onlt, if you want a alrger range then post back. Right
click your sheet tab, view code and paste this in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub
If Target.Address = "$C$3" And _
Target.Value 0 And _
IsNumeric(Target) Then
Application.EnableEvents = False
Target.Offset(, 1).Value = Now
Application.EnableEvents = True
End If
End Sub

Mike

"FirstVette52" wrote:

The cell needs to contain a 'Date/Time Stamp', so the TODAY() function is not
an option (always stamps the time as midnight).

Yes please, I would appreciate help with the code. I'm not a VBA Coder but I
understand it somewhat. Thank you both for your help! Greatly appreciated.
--
FirstVette52


"Shane Devenshire" wrote:

Hi,

You will probably have to consider a macro. Do you want to code this?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"FirstVette52" wrote:

Hey and thanks in advance

I need to insert the current date and time into a cell (that will not update
again) IF another cell is not empty:

IF(C30,NOW()," ")

However, this formula allows the date and time to update each time the
workbook functions update. I need the date to be fixed.

Thx!
--
FirstVette52