The date changed to a totally different day and year.

Any clue?

"Sweepea" wrote:

Question:

I cut and paste Value a date onto another area, and format that date
to Date format, but it's showing a different date.

Can someone help? Thanks a lot.