Dates Again!

[DWilliams]

Ok heres my problem, My student records worksheet enteres a test score date
automatically when a schore is entered in another cell. however, this date
changes everyday the formula is:
=IF(P25="","",NOW())
what is the solution?

 

[JE McGimpsey]

Take a look here:

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

 

[Bob Phillips]

See response to your other post.

--

HTH

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

 

[Harald Staff]

No. Your problem is your impatience and your manners.

Best wishes Harald

 

[DWilliams]

I'm sorry if i offended you it was not my intentions to do so. Ignorance to
the process not impatience contributed to the second message.

 

[DWilliams]

Thanks!

Take a look here:

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