+ Reply to Thread
Results 1 to 4 of 4

How to Convert date format ( DD/MM/YYYY) into MM/YYYY

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    332

    How to Convert date format ( DD/MM/YYYY) into MM/YYYY

    Please suggest an excel formula that how to convert date format 'DD/MM/YYYY" into "MM/YYYY'?

    For an example:-04/01/2014 should be Jan-2014 or Jan-14
    Regards


    Pradeep Kumar Gupta
    Gurgaon ( INDIA )

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,256

    Re: How to Convert date format ( DD/MM/YYYY) into MM/YYYY

    change cellformat to mmm-yyyy or mmm-yy
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    10-25-2012
    Location
    Bratislava, Slovakia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: How to Convert date format ( DD/MM/YYYY) into MM/YYYY

    You are able to make your own - so named "custom" formats.
    Right click follow Fomat cells... then Category: custom write to box Type: mm.yyyy and confirm ENTER.
    You can use also Type: mmmm "-" yyyy

    Or use something like this: =TEXT(A1;"mmmm.yyyy") suppose in cell A1 = 14.1.2014 => result is january.2014
    Or =TEXT(A1;"mmmm - yyyy")

    I hope it helped

  4. #4
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    332

    Re: How to Convert date format ( DD/MM/YYYY) into MM/YYYY

    Thanks for the nice formula.Glad.

+ 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. Replies: 7
    Last Post: 11-18-2012, 02:28 PM
  2. [SOLVED] convert MM/DD/YYYY to DD/MM/YYYY while the data format is text
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-18-2012, 02:43 PM
  3. [SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB
    By Boormo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-05-2012, 05:48 PM
  4. Macro to convert dates format from yyyy mm dd to yyyy-mm-dd
    By Gators in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-26-2009, 02:23 PM
  5. opening excel file -> date format problem: DD/MM/YYYY vs MM/DD/YYYY
    By yung in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2005, 09: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