Results 1 to 16 of 16

Extract Date from String

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-25-2014
    Location
    Italy - Currently In USA
    MS-Off Ver
    Excel 2019
    Posts
    213

    Unhappy Extract Date from String

    Hello Again, hopefully this will be the last time I annoy anyone for a Solution.

    The provided Data (attached) is where I am try to extract the Date and such is Driving me to the Wall.
    Each Description is different and that's why formula or VBA has been working on some rows and not others.
    Some Strings have full dates in them, others have just month and year and the rest have none or even week numbers.

    Dates and Excel don't get along well it seems

    Thank you for the attempt to resolve this matter.

    Cheers
    OP
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Can't extract date from a string
    By mz.mat in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-18-2022, 06:12 AM
  2. [SOLVED] How to extract date from middle of text string and add one month to the date.
    By JulianS96 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-02-2021, 07:36 AM
  3. Extract date from string
    By acandan21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-29-2021, 04:46 PM
  4. [SOLVED] How can I extract a date from a string?
    By Tooley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2017, 11:21 AM
  5. VBA to extract date from string
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-09-2016, 11:33 AM
  6. Extract date from string
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-01-2011, 08:39 AM
  7. extract date from string
    By kdp145 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2006, 10:54 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1