+ Reply to Thread
Results 1 to 4 of 4

Formula to reformat Date

  1. 01-19-2017, 01:41 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Formula to reformat Date

    Hello:

    I have formual in A1 = Today() which shows 1/19/2017

    I need formula in A2 to give result as 19-Jan-17_10687_DP

    Please let me know if you have any questions.
    Thanks.

    Riz
    Reply With QuoteRegister To Reply
  2. 01-19-2017, 01:45 PM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,937

    Re: Formula to reformat Date

    In A2:

    =TEXT(A1,"dd-mmm-yy")&"_10687_DP"
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 01-19-2017, 01:54 PM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Formula to reformat Date

    Hello AliGW:

    Thanks a lot, works for me.

    Riz
    Reply With QuoteRegister To Reply
  4. 01-19-2017, 01:55 PM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,937

    Re: Formula to reformat Date

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. date reformat with text in cell
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2015, 03:55 PM
  2. Reformat date
    By tuesday1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2013, 02:46 PM
  3. Formula to take the time out of a date cell and reformat said date
    By C_P in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-10-2013, 06:11 AM
  4. [SOLVED] Reformat a Date?
    By SueWithQuestion in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-27-2012, 09:18 AM
  5. How to reformat this date
    By SEMMatt in forum Excel General
    Replies: 2
    Last Post: 02-01-2012, 12:15 PM
  6. Reformat custom date format
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2011, 05:03 PM
  7. Reformat Date
    By mlindquist in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2006, 01:02 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