TODAY() and stay that date..

[Guest]

Hello,
I am using a sheet in which people electronically sign. They type in their
name in A1 and then A2 has the formula =IF(A1="","",TODAY()). The sheet
could have many signatures and dates. The problem is that the date on all
signatures change to what the date is when the sheet is opened. Is there a
better formula to use? Thanks,
Mike

 

[Peo Sjoblom]

See

http://www.mcgimpsey.com/excel/timestamp.html

--


Regards,

Peo Sjoblom

 

[Guest]

Mike,

Put the following code into the Sheet Object

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Target.Offset(, 1) = Format(Now(), "mm/dd/yyyy")
End If


End Sub

Anytime an entry is made into Column A, it will add today's date
automatically in Column B

http://HelpExcel.com