+ Reply to Thread
Results 1 to 4 of 4

how to convert the month in a date to the text word for that month

  1. #1
    Registered User
    Join Date
    06-09-2014
    MS-Off Ver
    13
    Posts
    7

    how to convert the month in a date to the text word for that month

    Hello All,
    I really appreciate your help on this.
    It may be simple for someone who does this often but I have tried everthing i know and can't get it to work.
    My last resort will be a new column with a lookup pulling the name of the month from another table.
    I am really trying to get away from so many tables and lookups.

    Here is my example
    There are two columns in my sheet for creation dates.
    My goal is to have the text name of the month appear in the second column.
    This is as far as i could get with formulas.
    Second column formula is just pulling in the month of the first column.
    =month(A1)

    How do I get the 10 in the second column to read October?

    CreateDate creation month
    10/1/2014 10
    10/21/2014 10
    10/21/2014 10
    10/30/2014 10
    10/30/2014 10
    10/30/2014 10
    10/30/2014 10
    10/30/2014 10

    Thank you very much.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: how to convert the month in a date to the text word for that month

    Try one of these...

    Where A1 is a date...

    For the short month name:

    =TEXT(A1,"mmm")

    For the long month name:

    =TEXT(A1,"mmmm")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    06-09-2014
    MS-Off Ver
    13
    Posts
    7

    Re: how to convert the month in a date to the text word for that month

    woo hoo! i knew it had to be something easy but i just wasn't getting it.
    Thank you. it worked!

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: how to convert the month in a date to the text word for that month

    You're welcome. Thanks for the feedback!


    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

+ 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. Convert Date (i.e. 8/1/2013) to Text Month (i.e. August)
    By kestefon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2013, 06:42 AM
  2. Convert date to month/year text
    By FindAnswers in forum Excel General
    Replies: 2
    Last Post: 11-07-2012, 03:42 PM
  3. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  4. Convert text into end of month date
    By freybe06 in forum Excel General
    Replies: 5
    Last Post: 04-11-2011, 03:13 AM
  5. Convert date from current month to first day of prior month
    By maacmaac in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-07-2010, 12:23 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1