+ Reply to Thread
Results 1 to 3 of 3

Date changes following Copy & Paste

  1. 09-23-2019, 04:58 PM #1
    brian guy
    brian guy is offline
    Registered User
    Join Date
    09-23-2019
    Location
    Burscough, England
    MS-Off Ver
    2010
    Posts
    2

    Date changes following Copy & Paste

    When copying from one spreadsheet to another, the dates increase by four years and a day.
    This happens whether or not the receiving spreadsheet cells are preformatted or not!!

    Tried all sorts - anyone experienced similar issues?

    Regards

    Brian
    Reply With QuoteRegister To Reply
  2. 09-23-2019, 05:04 PM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Date changes following Copy & Paste

    That sounds like one of the spreadsheets is set to use the alternative 1904 date system (a brief explanation here: http://www.cpearson.com/Excel/datetime.htm ). You will need to figure out which is which and correct the dates accordingly after pasting them.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  3. 09-23-2019, 05:44 PM #3
    brian guy
    brian guy is offline
    Registered User
    Join Date
    09-23-2019
    Location
    Burscough, England
    MS-Off Ver
    2010
    Posts
    2

    Re: Date changes following Copy & Paste

    Thanks - didn't know about that.
    Most grateful for your help!!

    Kind regards

    Brian
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA To Copy and Paste as Value on or after a certain date
    By Neilesh Kumar in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-14-2018, 05:17 AM
  2. [SOLVED] Copy,Cut, Paste Row to different sheet when date entered becomes todays date - Please Help
    By Mykull in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-11-2016, 01:55 PM
  3. copy paste based on a date
    By namluke in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-11-2015, 10:39 AM
  4. How to copy and paste date but maintaining the date format using macros
    By Wanjama in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-16-2014, 09:03 AM
  5. reference column date (yesterday) to get Month(Date) for copy paste
    By jukabub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-09-2013, 03:52 AM
  6. Reference a date, then copy and transpose paste into a date specific location
    By nelmsd in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-26-2013, 03:30 PM
  7. Excel 2008 : Copy/Paste date
    By nsandberg in forum Excel General
    Replies: 2
    Last Post: 07-15-2010, 06:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1