Scenario:
A sheet used to track customer request fulfillment has both a manually entered "Date" field and an automated "Created date" field. The idea being if needed, you could enter records after the fact and still track the correct date for reporting.
The data needs cleaning. I created a report for staff to easily see rows where "Date" is blank so they could copy "Created date" into that cell.
Problem:
From the report, I copied/pasted from "Created date" to "Date" and every time it pasted the wrong date. Sometimes it was a few days off, sometimes a few weeks.
From the source sheet, the pasted "Date" value matches "Created date".
How can I resolve this?
