Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Convert Dates: yyyymmdd To dd-mm-yy

  1. #1
    Join Date
    9th June 2004
    Location
    England
    Posts
    1,047

    Convert Dates: yyyymmdd To dd-mm-yy

    Attached is a file with dates from our main frame system which has been converted into an Excel file.

    I need to do some analysis which involves working out the number of days between today() and these dates.

    I have tried Format Custom to change the dates to dd/mm/yy but this doens't work, can any help please?
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Last edited by Timbo; October 6th, 2006 at 19:10.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    13th May 2006
    Location
    India
    Posts
    1,030

    Re: Change Date Format

    in B1 type this formula
    =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
    copy B1 down.
    and use column as dates
    you can format column B as you like

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Change Date Format

    Hi Tim,

    =TEXT(A1,"0000-00-00")+0

    Format the cell as date.

  4. #4
    Join Date
    9th June 2004
    Location
    England
    Posts
    1,047

    Re: Change Date Format

    Hi Kris,

    Many thanks.

    Tim.
    Last edited by Dave Hawley; October 31st, 2006 at 19:27.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Convert Numbers Representing Dates To True Dates
    By billyj in forum Excel General
    Replies: 7
    Last Post: June 30th, 2008, 09:31
  2. Convert YYYYMMDD to DD/MM/YYYY
    By chris_g in forum Excel General
    Replies: 8
    Last Post: August 24th, 2007, 23:28
  3. Convert Imported Text Dates to True Dates
    By sandyboath in forum Excel General
    Replies: 6
    Last Post: May 23rd, 2007, 08:31
  4. Replies: 2
    Last Post: January 24th, 2006, 15:01
  5. Convert YYYYMMDD to MM/DD/YYYY
    By Hueby in forum Excel General
    Replies: 2
    Last Post: November 24th, 2005, 02:42

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
  •  
porno