View Single Post
  #1   Report Post  
rrjohnsonia
 
Posts: n/a
Default Why do my dates change when I copy them between Excel worksheets?

I often copy cell contents from one worksheet and post them into a new one.
When I copy one set of dates and paste them into a new worksheet, the date
falls back one day and to 2001. For example, an original date of May 30, 2005
copies as May 29, 2001.

Our agency's IT guru can't figure it out. I could use some help to end this
frustrating error.

Thanks.