Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
If Range("A1") <> "" Then Range("A2") = Date
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
For i = 2 To 7500
If Not Intersect(Target, Range("D" & i)) Is Nothing Then
If Range("D" & i) <> "" Then Range("P" & i) = Date
End If
Next i
End Sub
=SI(A1="";"";SI(CELLULE("adresse";A1)=CELLULE("adresse");MAINTENANT();B1))