+ Reply to Thread
Results 1 to 2 of 2

Excel not recognizing next year (2015) in the date..instead returning the year as 1900!??

  1. 11-23-2014, 04:22 AM #1
    sbo123
    sbo123 is offline
    Registered User
    Join Date
    10-26-2014
    Location
    Kuwait
    MS-Off Ver
    2010
    Posts
    7

    Question Excel not recognizing next year (2015) in the date..instead returning the year as 1900!??

    Hi all,

    I have a sheet with various formulas and linking that finally results in a Date (Day, Date, Month, Year format).

    For some reason, all dates past 31st, December 2014 are displaying the year as 1900.. instead of 2015.

    Seems like something really silly am sure...Is it a formatting issue?

    Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 11-23-2014, 06:02 AM #2
    ELeGault
    ELeGault is offline
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: Excel not recognizing next year (2015) in the date..instead returning the year as 1900

    This means that your formulas are returning 0's in place of year...

    Mind posting a sample of this data and/or the formula that builds it, I am sure we can see what went wrong from there.
    -If you think you are done, Start over - ELeGault
    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. Keep month and date but change year to current year and reoccur when new year rolls over.
    By cdixon01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  2. [SOLVED] 1900 year date when filter column of dates
    By rz6657 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-03-2013, 12:18 PM
  3. Display 'Date' cell as blank instead of default year 1900
    By charger100 in forum Excel General
    Replies: 5
    Last Post: 11-19-2009, 05:21 PM
  4. [SOLVED] Excel thinks 1900 was a leap year???
    By CR in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2006, 05:30 PM
  5. format a cell to use mo/date with no year:,displays 1900?
    By SKI CLUB BILL in forum Excel General
    Replies: 2
    Last Post: 04-20-2006, 12:00 AM

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