Help with Dates!
 

How do i automatically enter a date that does not change everyday like it
does with the now() function?
--
DW

You can enter the date with CTRL+<semi-colon . It will not
update.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"DWilliams" wrote in
message
...
How do i automatically enter a date that does not change
everyday like it
does with the now() function?
--
DW

Thanks Chip for your response. My problems is i have my student file set up
to where it automatically enters a test score date once the test score is
entered. however i have discovered the dates change every time i reopen the
worksheet the following day the formula is:
=IF(P25="","",NOW())
is there a way to have the date automatically enter and not change?

"Chip Pearson" wrote:

You can enter the date with CTRL+<semi-colon . It will not
update.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"DWilliams" wrote in
message
...
How do i automatically enter a date that does not change
everyday like it
does with the now() function?
--
DW

Yes, with a simple macro. Rightclick the sheet tab, choose "view code",
paste this in the

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$C$1" Then Range("C1").Value = Now
End Sub

HTH. Best wishes Harald


"DWilliams" skrev i melding
...
Thanks Chip for your response. My problems is i have my student file set
up
to where it automatically enters a test score date once the test score is
entered. however i have discovered the dates change every time i reopen
the
worksheet the following day the formula is:
=IF(P25="","",NOW())
is there a way to have the date automatically enter and not change?

"Chip Pearson" wrote:

You can enter the date with CTRL+<semi-colon . It will not
update.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"DWilliams" wrote in
message
...
How do i automatically enter a date that does not change
everyday like it
does with the now() function?
--
DW

Sounds that you need event code


Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("P1:P100")) Is Nothing Then
Target.Offset(0, 1).Value = Format(Date, "dd mmm,yyyy")
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DWilliams" wrote in message
...
Thanks Chip for your response. My problems is i have my student file set
up
to where it automatically enters a test score date once the test score is
entered. however i have discovered the dates change every time i reopen
the
worksheet the following day the formula is:
=IF(P25="","",NOW())
is there a way to have the date automatically enter and not change?

"Chip Pearson" wrote:

You can enter the date with CTRL+<semi-colon . It will not
update.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"DWilliams" wrote in
message
...
How do i automatically enter a date that does not change
everyday like it
does with the now() function?
--
DW