Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#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 | |
|
|
Similar Threads | ||||
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) |