Insert todays date but make sure it doesn't change

**smash96** · 03-19-2014, 08:10 AM

Hi there,
Just a question I have a button and when I press it, it shows a tick so the user knows when it's been clicked I also want it to insert the date it was clicked but obviously if I use the =TODAY() formula it would change everyday. I need to keep it the same after each day.
if you could help that would be great thanks.

**Fotis1991** · 03-19-2014, 08:13 AM

Hello

You need TimeStamp for this.

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

**smash96** · 03-19-2014, 02:41 PM

thankyou Fotis 1991, that link really helped i just need to implement it into my worksheet but thankyou !

**smash96** · 04-01-2014, 04:16 AM

I found this out on another website maybe it would be useful for other people
1.Press [Ctrl][F3].
2.Enter DateStamp in the Names In Workbook text box.
3.In the Refers To text box, enter the following formula:
=TEXT(TODAY(),"d-mmmm-yyyy") & " " & TEXT(NOW(),"h:mm AM/PM")
4.Click the Add button and then click OK.