Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts

    Convert string to date

    Hi All

    i want to convert string to date, currently i have the date in string format.

    oct,2009
    dec,2009 and so on. I want this string convert to date format.

    Thanks
    farrukh

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    Farrakh:

    To have a date formula you will need the following numbers
    1. Year Month Day

    Using a simple Vlookup table and assuming the day is always 1 the attached will convert the above string to a serial date.

    Hope this helps,

    Tom Duthie
    Attached Files Attached Files

  3. The Following User Says Thank You to duthiet For This Useful Post:

    farrukh (2011-06-16)

  4. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    It can be done without a lookup by using a formula like:
    =DATEVALUE(SUBSTITUTE(A1,","," 1, "))

    This will make the date the first of the month. You can change the "1" to whatever day of the month desired.

    Steve

  5. The Following User Says Thank You to sdckapr For This Useful Post:

    farrukh (2011-06-16)

  6. #4
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Hi duthiet and Steve,

    Thank you so much for your kindness great

    Thanks
    farrukh

Posting Permissions

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