Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formula to format imported date problem (Office XP)

    Hi all,

    Admit and Discharge Dates are unfortunately imported without format or leading zero, resulting in either 7 or 8 characters( mddyyyy AND mmddyyyy) I need to get into date format do I can calculate days. Unfortunately I saved the result but not my formulas . I had done this a few months ago but have forgotten what I did! I am afflicted with Old TImer's!!!!!!! Please help!

    Thanks!
    Dale

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: formula to format imported date problem (Office XP)

    See the replies to <post#=337261>post 337261</post#>. You'll find various approaches.

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: formula to format imported date problem (Office XP)

    A formula that would convert those numbers to dates is:
    =DATE(RIGHT(A1,4),LEFT(A1,LEN(A1)-6),MID(A1,LEN(A1)-5,2))

  4. #4
    New Lounger
    Join Date
    May 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formula to format imported date problem (Office XP)

    Thanks Hans!

    It's such a great timesaver to have access to you everyone's shared knowledge. I really appreciate it!

    Thanks again, Dale

  5. #5
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formula to format imported date problem (Office XP)

    Yet another way is on the attached. Developed from a thing I had to do for real only yesterday, probelm was to get xl to interpret numbers entered like 0928 or 1537 as times. Much easier to enter them this way!

Posting Permissions

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