you need to used th esheet's changed event to populate the cell with the
actual date/time. If yuo use a formula, then that will change each time the
sheet recalculates.
right click the sheet tab & select the code page. Add this...


Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$AV$17" Then
Target.Offset(0, 1) = Format$(Now, "dd/mm/yy hh:mm")
End If
End Sub



"Phil Hageman" wrote:

> Cell AV17 holds data that is periodically updated. In cell AV18 I need a
> formula to have the date of the AV17 update automatically inserted. What
> would the formula be?