Dates Again!
 

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?
--
DW

Take a look he

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


In article ,
DWilliams wrote:

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?

See response to your other post.

--

HTH

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


"DWilliams" wrote in message
...
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?
--
DW

No. Your problem is your impatience and your manners.

Best wishes Harald

"DWilliams" skrev i melding
...
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?
--
DW

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.

"Harald Staff" wrote:

No. Your problem is your impatience and your manners.

Best wishes Harald

"DWilliams" skrev i melding
...
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?
--
DW

Thanks!


"JE McGimpsey" wrote:

Take a look he

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


In article ,
DWilliams wrote:

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?