Hi,

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$8" Then
Target.Offset(-7) = Format(Date, " dddd dd mm yyyy")
End If
End Sub

Mike

"puiuluipui" wrote:

Hi, i need the date and day in C1, but only when i write something in C8. And
when i close the workbook, and open it again, the date to remain the same.

Ex:
Today is MONDAY 03.11.2008

When i write something in C8, "MONDAY 03.11.2008" to appear in C1.
If i close the workbook, i need the date to be saved.
If i open the workbook after 3 days, C1 to show me the same "MONDAY
03.11.2008"
Can it be done?
Thank you in advance.