+ Reply to Thread
Results 1 to 3 of 3

Date Format : Thu, 2-Feb-2020

  1. #1
    Registered User
    Join Date
    02-18-2020
    Location
    Philippines
    MS-Off Ver
    2017
    Posts
    36

    Date Format : Thu, 2-Feb-2020

    How to do this so I can customize my date?

    Example --- Thu, 2-Feb-2020

    Concatenate won't work.
    Last edited by kayafueya; 02-27-2020 at 04:10 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,837

    Re: Date Format : Thu, 2-Feb-2020

    IF the cell holds an Excel date, then custom format with:
    ddd, dd-mmm-yyyy

    if it does not, then post a sample workbook.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    02-18-2020
    Location
    Philippines
    MS-Off Ver
    2017
    Posts
    36

    Re: Date Format : Thu, 2-Feb-2020

    oh I'm so dumb. Thank you!!!

+ 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. Call in the Cavalry - 2020
    By JBeaucaire in forum The Water Cooler
    Replies: 97
    Last Post: 12-15-2020, 04:27 PM
  2. [SOLVED] Excel app won't accept 2020 dates on one tab, but will on other tabs
    By JimPT in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2020, 01:16 PM
  3. Replies: 4
    Last Post: 01-17-2020, 04:23 AM
  4. Rolling Spreadsheet Data to 2020 - INDEX/Match?
    By DedZed in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-13-2019, 04:29 PM
  5. [SOLVED] Correct exported date of 3/20/2019 to 3/1/2020
    By aquixano in forum Excel General
    Replies: 4
    Last Post: 09-20-2019, 11:32 AM
  6. Update calendar for 2013 - 2020 with events from the database sheet
    By ganzzu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2013, 08:58 AM
  7. Replies: 5
    Last Post: 02-08-2013, 11:06 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