+ Reply to Thread
Results 1 to 3 of 3

Various Non Standard Dates

  1. #1
    Registered User
    Join Date
    05-16-2020
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    1

    Various Non Standard Dates

    Hi,

    I have various non-standard dates in different formats in the same column (see attached), I would like to fix this and make them all into the same format but I am currently struggling. Any help would be greatly appreciated.

    Excel Screenshot.PNG

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,913

    Re: Various Non Standard Dates

    Please look at the yellow banner at the top of this page on how to upload a sample file.

  3. #3
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,851

    Re: Various Non Standard Dates

    per prior post, going forward, sample files help but, ... based on your samples, and per UK region, the below should work:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF Regular or Standard Hours show as "Regular,Standard"
    By BigErnKingpin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-03-2019, 04:24 AM
  2. Make standard deviation of a sample IF data is within specific dates
    By oriyuno in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-01-2019, 10:28 AM
  3. [SOLVED] Converting multiple non-standard time formats to one standard?
    By RandyStone in forum Excel General
    Replies: 6
    Last Post: 06-14-2018, 07:40 AM
  4. [SOLVED] Converting non-standard dates
    By heytherejem in forum Excel General
    Replies: 10
    Last Post: 07-07-2017, 11:04 AM
  5. Replies: 11
    Last Post: 09-01-2016, 04:45 AM
  6. Need Macros to send standard e-mail based on dates
    By jameslav2003 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2013, 11:10 AM
  7. Convert dates like 2007.15 into standard format
    By Deviad in forum Excel General
    Replies: 9
    Last Post: 05-11-2010, 08:02 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