View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CAMiller CAMiller is offline
external usenet poster
 
Posts: 1
Default When copying dates, they change by 4 yrs & 1 day, why?

When copying & pasting dates in a few of my worksheets, they change to one
day and four years backwards, ie: 07/15/1979 changes to 07/14/1975.

Can anyone tell me what I am doing wrong?

Thank you,