" wrote:

I have a worksheet, which is a log of clients I see everyday and it
goes for 2 weeks at a time. How can I use one of the functions, ie:
today(), and have the worksheet pick up the correct date everyday, but
without updating the previous dates in that worksheet?

Thank you in advance.

Hernan.

Try entering this as the code for a workbook page

Private Sub worksheet_activate()
Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveCell = Date
End Sub

Each time the sheet is opened, the date is put into the next empty cell