Today's Date

Dave Gibson · Feb 26th, 2002, 01:56 PM

Is there any way to automatically enter today's date in a new sheet and have that date stay the same every time you open it? In other words, I don't want to use the Today() function, I want to keep the same date that the worksheet was first created. Thanks.

Aladin Akyurek · Feb 26th, 2002, 01:59 PM

Quote:

On 2002-02-26 12:56, Dave Gibson wrote:
Is there any way to automatically enter today's date in a new sheet and have that date stay the same every time you open it? In other words, I don't want to use the Today() function, I want to keep the same date that the worksheet was first created. Thanks.

Enter date with: CONTROL + ;

Feb 26th, 2002, 02:01 PM

try control ;

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

Feb 26th, 2002, 01:56 PM	#1
Dave Gibson New Member Join Date: Feb 2002 Posts: 6	Is there any way to automatically enter today's date in a new sheet and have that date stay the same every time you open it? In other words, I don't want to use the Today() function, I want to keep the same date that the worksheet was first created. Thanks.