+ Reply to Thread
Results 1 to 3 of 3

Decoding strange date format

  1. #1
    Registered User
    Join Date
    01-08-2012
    Location
    Czech Rep
    MS-Off Ver
    Excel 2010
    Posts
    7

    Decoding strange date format

    Is there a non-macro function which could decode this?

    Column A --- Column B
    62171 --- 1.1.1753
    136173 --- 13.8.1955
    136174 --- 14.8.1955
    136205 --- 14.9.1955
    136571 ---14.9.1956

    The numbers in Column A are some sort of integers which represent the dates in Column B. I did not decode those example days by myself, but by using an external program (it's a game database editor). I can see that +1 one day in Column B = +1 in the Column A, however I fail to decode the whole formula. I've extracted the values from the database via that editor, but they could be exported only in the format in Column A and I would like to convert them via a function to the Column B format (and then to current age based on the date).

    Could you please tell me, how to do that?
    Last edited by viktoristus; 08-03-2013 at 03:59 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Decoding strange date format

    Subtract 115,859 from column A and format as date. However, this will not work for dates before 1/1/1900.

  3. #3
    Registered User
    Join Date
    01-08-2012
    Location
    Czech Rep
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Decoding strange date format

    Problem solved, thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating duration with strange date / time format
    By chrispx001 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2013, 11:08 AM
  2. Strange results from DATEDIF (Month to date) if the second date changed !
    By bebo021999 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-01-2013, 06:46 AM
  3. converting "strange" date format to standard date format
    By perinouk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2007, 02:09 PM
  4. [SOLVED] strange date format problem
    By amag in forum Excel General
    Replies: 2
    Last Post: 06-03-2006, 08:10 AM
  5. [SOLVED] Strange Format changes
    By Dan Wilson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-14-2005, 11:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1