Adding dates within Excel automatically

Mar 11th, 2002, 01:29 PM

Ok, the problem I am having is that I have created a basic macro to automatically add the date to my spreadsheet when a button is clicked. I used the short cut "Ctrl ;" to add the date but the problem is when i go to run the macro the next day it adds yesterday's date again. I was wondering if anyone knew how I could fix this problem? Thanks for your help, Bex

Steve Hartman · Mar 11th, 2002, 01:49 PM

=TODAY() will put today's date in a cell whenever you open the workbook. Of course every time you open it, you will get that day's date.

Steve Hartman · Mar 11th, 2002, 01:51 PM

Sorry, the word macro went right over my head. In VBA use DATE.

Mar 11th, 2002, 01:58 PM

Thank you very much Steve, that was a great help, Bex

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 01:29 PM	#1
Guest Posts: n/a	Ok, the problem I am having is that I have created a basic macro to automatically add the date to my spreadsheet when a button is clicked. I used the short cut "Ctrl ;" to add the date but the problem is when i go to run the macro the next day it adds yesterday's date again. I was wondering if anyone knew how I could fix this problem? Thanks for your help, Bex

Mar 11th, 2002, 01:49 PM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	=TODAY() will put today's date in a cell whenever you open the workbook. Of course every time you open it, you will get that day's date.

Mar 11th, 2002, 01:51 PM	#3
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Sorry, the word macro went right over my head. In VBA use DATE.

Mar 11th, 2002, 01:58 PM	#4
Guest Posts: n/a	Thank you very much Steve, that was a great help, Bex