Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Exchanging a month number to its assigned month name

    I have a schedule with a fiscal year starting in JULY, month = 7 as a date. I already separated the month numbers from the dates of service. in another column ( call it MO Column). I need to read the month number ( ie; 7) and have it record July. I will copy the the formula down to write out all the months in the MO Column.

    Could this be done. I thought I remembered seeing this but I cannot find it nor do I know what it would be called.

    Help, as always, is greatly appreciated.

    Thank you.

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Assuming the dates begin in the A2 cell (e.g., 1/28/2016), fill this down in the B column: =TEXT(A2,"mmmm")

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    The formula works and that's great! However, isn't there a formula that will correspond the month number to the month name automatically??

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    MNN,

    You can also do something like:
    =CHOOSE(A1,"January","Febuary","March","April","Ma y", etc.) where cell A1 is an integer.

    HTH,
    Maud

  5. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,435
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    MNN,

    Another approach...
    MNN-Months.PNG

    This method just references the cell w/the date and uses a custom date format.

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. #6
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Since I am dealing with fiscal years, I need something to identify the month number or name with the MONTH SEQUENCE of the Fiscal Year. For instance, July starts the Fiscal Year so that would be "MONTH 1" of the fiscal year. August would be "Month 2" January is "Month 7" and May is "Month 11" and so it goes.

    I have the fiscal year formula down and that is working properly, but I need to capture the Month Number of the Fiscal Year.

    Any suggestions.

    Thanks

  7. #7
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    =CHOOSE(A1,"July","August","September","October"," November", etc.) where cell A1 is an integer.

  8. #8
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 984 Times in 914 Posts
    If A1 contains a date you can do this.

    =IF(MONTH(A1)>6,MONTH(A1)-6,MONTH(A1)+6)

    Capture.PNG

    cheers, Paul
    Last edited by Paul T; 2016-02-01 at 02:32.

Posting Permissions

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