+ 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, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Various Non Standard Dates

    Please look at the yellow banner at the top of this page on how to upload a sample file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

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

    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