Results 1 to 3 of 3

Excel Text to date formula

Threaded View

spr2017 Excel Text to date formula 03-19-2019, 07:46 PM
TMS Re: Excel Text to date formula 03-19-2019, 08:01 PM
TMS Re: Excel Text to date formula 03-19-2019, 10:22 PM
  1. 03-19-2019, 07:46 PM #1
    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
« 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