Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel - Display Month from Date (2003 SP3)

    I need to report the name of the month from multiple dates. I have been using the =MONTH() function but it only reports back the month of January. I have changed the format cell to custom "mmm" so it will report the alpha i.e. 1/01/2009 (January 1, 2009) is displaying "Jan" but for another date say 1/2/09 (February 1, 2009) it is still reporting "Jan" in the cell where the =month() is. Can someone please tell me what I am doing wrong? I have attached a ss with the problem. Thanks.
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Display Month from Date (2003 SP3)

    You are formatting the month number as the alpha representation, the formatting does not work using this method. You need to format the date itself as the alpha representation. Change your formulas in the B column to =A1 and you will see the correct alpha month name.

  3. #3
    New Lounger
    Join Date
    Nov 2003
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Display Month from Date (2003 SP3)

    Thanks. I have it linked to a Pivot table so wanted the "month" to come over. Using the =month() was reporting back the numeric 1-12 but wanted the actually month names. Thought I had to change the formatting to display it correctly but the formula didn't work once I change the formatting and imported other dates past January. Initially I thought it had worked using January data. Thanks for quick reply. :-) Very much appreciated.

  4. #4
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Display Month from Date (2003 SP3)

    Hi

    what about this

    =TEXT(A1,"mmm")

    Note that this formula return a string
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •