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?
Bookmarks