Results 1 to 3 of 3

Thread: Text to Date.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular countryfan_nt's Avatar
    Join Date
    May 2004
    Location
    Saudi Arabia
    Posts
    656
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Text to Date.

    Hello friends, hope all is well!

    the cell A1 has this: 9/18/2018 12:00:00 AM

    the Cell is not recognized as a date. Can you please help provide me with a formula that will convert this to date i.e. 18-Sep-2018 ?


    Thank you very much in advance!

  2. #2
    Board Regular
    Join Date
    Sep 2016
    Posts
    2,572
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

  3. #3
    Board Regular
    Join Date
    Jul 2008
    Location
    France Alsace
    Posts
    1,246
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Text to Date.

    Here a UDF which can help you
    Somewhere put =MyDate(A1)
    Code:
    Option Explicit
    
    
    Function MyDate(ByVal WkRg As Range) As Date
    Dim T
        T = Trim(Left(WkRg, 10))
        T = Split(T, "/")
        MyDate = DateSerial(T(2), T(0), T(1))
    End Function

Some videos you may like

User Tag List

Tags for this Thread

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
  •