Results 1 to 3 of 3

Thread: Extracting the date

  1. #1
    Neophyte MGB's Avatar
    Join Date
    Jul 2019
    Posts
    2
    Articles
    0
    Excel Version
    365

    Extracting the date



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi
    I've just received a .csv file with cells containing data in the following format:

    2017-12-12T00:51:05Z
    Is it possible to extract just the date from this format? ie 12/12/2017

    Regards

    Mike

    PS This is in Excel 365 using Windows 10
    Last edited by MGB; 2019-07-03 at 08:25 PM.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,568
    Articles
    0
    Excel Version
    365
    if that text is in C1 then:
    =DATEVALUE(LEFT(C1,10))
    formatted in any date format you like.

  3. #3
    Neophyte MGB's Avatar
    Join Date
    Jul 2019
    Posts
    2
    Articles
    0
    Excel Version
    365
    You're a star; worked perfectly. Thank you so much.

    Regards

    Mike

Posting Permissions

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