date formula Help!!

[goju]

Please Help!!

i need a formule for the following:

When i input text into c3 in a worksheet i would like todays date to automatically go in c1, however would like the date to stay the same, when opened a week later. So,

when i input text in c3 c1 shows todays date then when i save this and re open tomorrow or next week it still todays date in and not tomorrows or when ever i open it.

any help appricated.

 

[yee388]

I don't believe you can accomplish this with a formula. However, a Worksheet_Change macro similar to the following should do the trick...

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Count > 1 Or Target.Address <> "$C$3" Or Target = "" Then Exit Sub

Range("C1").Value = Date

End Sub