Hello Allen, I guess the excel from which you are getting thadates from is in 1904 date system. and yours is in 1900 date system. All you need to do is to uncheck the "use 1904 data system" in your source excel - excel options.
This is my first thought. let me know if it helps. On Wed, Jan 13, 2010 at 8:16 AM, Allen Miller <al...@millermanor.net> wrote: > Here's a good one. I was a spreadsheet jockey a long time ago. I am > an IT Consultant now - mostly doing server & network management. This > one has me puzzled. > > A client contacted me and said he got a (2007) spreadsheet somewhere > and just wanted to copy 2 columns from it to a new spreadsheet. One > of the columns had dates in it. When he copied the dates from the > source spreadsheet to the target spreadsheet - all the dates changed > by a time factor of 4 years and 1 day! I asked him to send me the > spreadsheet and when I followed his steps - and copied several dates > from the source spreadsheet to a new spreadsheet that I had created - > the exact same thing happened - the dates all moved 4 years and 1 day > earlier. > > I would sure appreciate your help explaining this if you can. > > The dates are entered as values and there are no funky formats being > used. > > Thanks. > Regards, > Allen > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > >
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
