+ Reply to Thread
Results 1 to 8 of 8

Simple formula to display a date (10/19/2013) as text (October 2013)

  1. #1
    Registered User
    Join Date
    09-12-2013
    Location
    Los angeles, CA
    MS-Off Ver
    Excel 2013
    Posts
    60

    Simple formula to display a date (10/19/2013) as text (October 2013)

    Sorry I know this is lame.
    I have a column showing dates like so:

    10/19/2013.

    I want to add a column next to it to display this as October 2013.

    Anyone can help?

    Thanks so much

  2. #2
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: Simple formula to display a date (10/19/2013) as text (October 2013)

    Assume your data on A2, place this code on B2
    Please Login or Register  to view this content.
    Note: make sure your data on date format
    Click (*) if you received helpful response.

    Regards,
    David

  3. #3
    Registered User
    Join Date
    09-12-2013
    Location
    Los angeles, CA
    MS-Off Ver
    Excel 2013
    Posts
    60

    Re: Simple formula to display a date (10/19/2013) as text (October 2013)

    THANKS!

    Also - do you know how I can make all dates on a column be the same:

    8/31/2013
    8.6.13


    So they are presented the same way instead of one with / and other with .

  4. #4
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: Simple formula to display a date (10/19/2013) as text (October 2013)

    One question: the format of your data are fix? Event with "/", "." or "-"?
    I mean: month/day/year, month.day.year or month-day-year ?

  5. #5
    Registered User
    Join Date
    09-12-2013
    Location
    Los angeles, CA
    MS-Off Ver
    Excel 2013
    Posts
    60

    Re: Simple formula to display a date (10/19/2013) as text (October 2013)

    Idk ):
    here is the column - notice for example 616 and others:


    Unifying DATE format - notice 616.xlsx

  6. #6
    Registered User
    Join Date
    09-12-2013
    Location
    Los angeles, CA
    MS-Off Ver
    Excel 2013
    Posts
    60

    Re: Simple formula to display a date (10/19/2013) as text (October 2013)

    The reason I am asking is that I would like to add a FILTER, and so I need the entire column to be unified.

    Turning all DATES to the same format. Let's say, they all will look like this:

    10/20/2013

  7. #7
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: Simple formula to display a date (10/19/2013) as text (October 2013)

    I see your data, the different format only use "." and I assume all format month.day.year
    so use this:

    Please Login or Register  to view this content.
    by the way, for the year, because it's only 2 digit, I assume it's as >=2000

  8. #8
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: Simple formula to display a date (10/19/2013) as text (October 2013)

    I forgot, if the column already format as date, you don't need use this formula:
    Please Login or Register  to view this content.
    instead use format cell
    1. go to home, format, format cell... or right click the cell and choose format cell...
    2. in tab number, choose custom, and on field "type:" type "mmmm yyyy" (without quote "")

+ 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. excel 2013 and autocad 2013 LT
    By drailed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2013, 03:05 PM
  2. Replies: 3
    Last Post: 09-12-2013, 06:23 PM
  3. Link Excel 2013 to Word 2013
    By drosen99 in forum Word Formatting & General
    Replies: 20
    Last Post: 02-26-2013, 08:20 PM
  4. Replies: 7
    Last Post: 01-03-2013, 04:13 PM
  5. Replies: 2
    Last Post: 11-04-2012, 04:57 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