+ Reply to Thread
Results 1 to 3 of 3

Using LOOKUP to assign month names to cells with dates.

  1. #1
    Registered User
    Join Date
    01-31-2013
    Location
    Norway
    MS-Off Ver
    2013
    Posts
    12

    Using LOOKUP to assign month names to cells with dates.

    Hi there,

    The title is probably a bit confusing, but I wasn't sure how to formulate my problem. I'll try here:

    I have a column with lots of dates/times (in the "dd.mm.yy hh:mm" format). I want to use the LOOKUP function to check the month each date is in and get the name of the month in a new column.

    Formula:

    =LOOKUP(F2;{MONTH(1);MONTH(2);MONTH(3);MONTH(4);MONTH(5);MONTH(6);MONTH(7);MONTH(8);MONTH(9);MONTH(10);MONTH(11);MONTH(12)};{"Jan";"Feb";"Mar";"Apr";"May";"Jun";"Jul";"Aug";"Sept";"Oct";"Nov";"Dec"})

    I'm just getting error messages, and I can't really figure out what I am doing wrong. Can anyone help me out?

  2. #2
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: Using LOOKUP to assign month names to cells with dates.

    try this
    =TEXT(MONTH(F2),"MMM")

  3. #3
    Registered User
    Join Date
    01-31-2013
    Location
    Norway
    MS-Off Ver
    2013
    Posts
    12

    Re: Using LOOKUP to assign month names to cells with dates.

    Hi Ghozi,

    Thanks, that almost did it. However, it's only coming out as January no matter what month the date is. Any idea why?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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