Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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? |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
#5
![]() |
|||
|
|||
![]()
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 |
#6
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Dates in a date range | Excel Discussion (Misc queries) | |||
Plotting Dates | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) |