+ Reply to Thread
Results 1 to 6 of 6

How can i show date in this form (month,last date of that month, Year)?

  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    How can i show date in this form (month,last date of that month, Year)?

    How can i show date in this form (month,last date of that month, Year)?

    09302014
    08312014
    10312014
    Click on (*), if you agree.

  2. #2
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    Re: How can i show date in this form (month,last date of that month, Year)?

    Can anyone reply to this email?

  3. #3
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: How can i show date in this form (month,last date of that month, Year)?

    Hi,

    you could use a customized format

    mmddyyy

    Hope it helps
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  4. #4
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    Re: How can i show date in this form (month,last date of that month, Year)?

    I want to get last month date of every previous month.

  5. #5
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: How can i show date in this form (month,last date of that month, Year)?

    Is that date formatted as text? If yes maybe:

    =VALUE(MID(A1,3,2))&", "&EOMONTH(VALUE(LEFT(A1,2)),0)&", "&VALUE(RIGHT(A1,4))

  6. #6
    Registered User
    Join Date
    10-24-2014
    Location
    Sweden
    MS-Off Ver
    2007
    Posts
    1

    Re: How can i show date in this form (month,last date of that month, Year)?

    You can use the following formula to create the date for the last day of the month.

    Please Login or Register  to view this content.
    Cell A1 contains a date.

    If A1 contains 2014-10-24 then the formula will return the date 2014-10-31.

    Use customer number formatting to create the date format you wish to use. For more information see http://office.microsoft.com/en-us/ex...010342372.aspx.

+ 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. Sort month/date/year data using month and date only
    By SMW820 in forum Excel General
    Replies: 8
    Last Post: 11-18-2014, 08:39 AM
  2. Need to convert Month/Date/Year to Year/Month/Date so excel will recognize
    By juliettelam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2014, 04:17 PM
  3. [SOLVED] Date to show only date w/o month or year
    By jazbath in forum Excel General
    Replies: 4
    Last Post: 01-09-2013, 10:08 PM
  4. [SOLVED] How to show yesterdays date without month year.
    By DKerr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2012, 10:17 AM
  5. Adding month and year to form date
    By Dino in forum Excel General
    Replies: 2
    Last Post: 11-17-2005, 10:10 PM

Tags for this Thread

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