Results 1 to 2 of 2

Thread: Date format
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Date format

    Hi, i have converted on PDF file to Excel but date format is messed up. im trying to minus one date from another to find the number of days but some of the giving me #value! msg. No matter how many time i tried its the same. how to change it to date format, please help

    15/04/13 30/06/13 #VALUE!
    15/05/13 30/06/14 #VALUE!
    16/05/13 30/06/15 #VALUE!
    02/06/13 30/06/16 #VALUE!
    03/06/13 30/06/17 #VALUE!
    04/06/13 30/06/18 #VALUE!
    27/06/13 30/06/19 #VALUE!
    28/06/13 30/06/20 #VALUE!
    29/06/13 30/06/21 #VALUE!
    15/05/13 30/06/22 #VALUE!





    thanks in advance

  2. #2
    Board Regular Akashwani's Avatar
    Join Date
    Mar 2009
    Posts
    2,900
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Date format

    Hi and welcome to MrExcel.

    Take a look here and see if Chandoo has the solution you require....

    How to Convert Text to Dates [Data Cleanup] | Chandoo.org - Learn Microsoft Excel Online

    I hope that helps.

    Ak
    A reply is not only helpful to others, but polite to those who have provided a solution!!

    To post sample data go here....
    HtmlMaker
    Excel Genie
    Use Borders

    Upload a Sample File


    Visit here for some EXCELlent videos...

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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