The idea is simple, I'd like a function I could do something like =MOD_DATE_OF(A1:A4) and when any of the cells in such range is modified, the cell I assigned that formula gets the current date.

I have found some similar questions on the web and even here, but none of them quite it.

The closest I've got was this code somewhere (sorry, lost track of the source):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    If Target.Column = 1 Then
        Target.Offset(0, 1).Value = Date
    End If
End Sub

But it is still not a function..

I am using Excel from Office 2010

thanks