+ Reply to Thread
Results 1 to 3 of 3

Excel Text to date formula

  1. 03-19-2019, 07:46 PM #1
    spr2017
    spr2017 is offline
    Registered User
    Join Date
    11-21-2017
    Location
    SYDNEY
    MS-Off Ver
    2016
    Posts
    35

    Excel Text to date formula

    I know this is simple but i'm unable to get the date for these fields. please see sample attached. I just need it to be a simple date "dd-mm-yyy"
    Attached Files Attached Files
    Last edited by spr2017; 03-19-2019 at 08:14 PM.
    Reply With QuoteRegister To Reply
  2. 03-19-2019, 08:01 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,303

    Re: Excel Text to date formula

    Not sure what you are looking for. Maybe
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 03-19-2019, 10:22 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,303

    Re: Excel Text to date formula

    Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating an excel formula that extracts the date from a string of gibberish text
    By Randomizador in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-25-2019, 11:56 PM
  2. Formula to find the earliest date in excel base on a given date and text
    By Rikii Sumat in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-27-2017, 02:35 AM
  3. Formula showing a TEXT & date, in the next column i need to add 2 days on the date
    By JessSilvertail in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2016, 05:42 AM
  4. [SOLVED] IF & EDATE Formula together for an End Date but how to ignore text in start date cell
    By Skum in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-24-2013, 02:40 PM
  5. excel formula to count cells with specific text with a date condition, older that 10 days
    By tajny in forum Excel General
    Replies: 8
    Last Post: 07-13-2012, 09:02 AM
  6. Formula to convert text to a date in a date format
    By mikeburg in forum Excel General
    Replies: 5
    Last Post: 08-24-2011, 09:15 AM
  7. Formula Help: display text if Cell (date) is within date range
    By HarveyV in forum Excel General
    Replies: 1
    Last Post: 03-16-2011, 11:05 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1