Here is some VBA code that will write the current date like a timestamp in a
cell that you choose. Of course you will have to set the sheetname and cell

Sub TimeStamp()
Sheets("YourSheetName").Range("A1").Value = Now()
End Sub

To get it to work you need to put it in a normal module instructions are he
http://www.contextures.com/xlvba01.html

To run it you can put a button in your sheet very easily.
Edit Toolbars Forms

Click on the one called button and drag a button in your worksheet.
When you have done this, link it to the macro called TimeStamp that you have
set up.

Now you just need to bang on that button every time you want to update the
date.
The button can be in either sheet, it doesn't matter.

--
Allllen


"Jesse" wrote:

How I can put static date by using any formula in excel. For ex. In Sheet 1 i
have entered payment is paid. I want to record on sheet 2 the date and time
automatical when it is paid.I used Now() function,but it changes whenever i
open my sheet. I want to use it like a Stamp.thanks
I don't Want to PUT MANUALLY everytime, i just want date and time there like
a stamp
I TRIED CTL+; and so on
thanks