I'm new at this, and I'm not sure exactly what you are attempting to do... but try this:
 Cells(Target.Row, 5) = Format(Now, "MM-DD-YYYY_hh-mm-ss")
This what I use for my spreadsheets. You may want to set it to 
Format(Now, "MM-DD-YYYY").